RE: [Firebird-devel] Threading

[Jason L. <lo...@ai...>]

Well, the simple fact of the matter is that if Firebird offered a way to use
more than one processor (even 1 thread per connection) it would be a great
selling point to it over Interbase.  And as soon as multiprocessors are
supported, I'm going to go buy a 2-way server...  There are some reports
that we do, (a lot less now that I know about plans and how to optimize
indexes), that take a long time to run and basically take control of the
engine.  If that could run to its heart's content on one processor while
still leaving half of the power available for interactive requests (or
another big query), I would be MUCH happier.  

The other thing is that Firebird needs to have some method of specifying
priorities of queries or some way to allow other queries to get a fair share
of processing power.  I admit that most of my problems with runaway queries
have been caused by lack of indexes and sheer inexperience with database
design, but Firebird is supposed to be the "no management needed" db.

--Jason

-----Original Message-----
From: Mike Nordell [mailto:ta...@al...]
Sent: Thursday, May 24, 2001 11:14 AM
To: fir...@li...
Subject: Re: [Firebird-devel] Threading


Ann W. Harrison wrote:
>
> Not questioning the conclusion, but one can get a perfectly nice dual
> processor (P3, 800 Mh) for less than $2000.  They're in our future.

Sure they are. They have been in our future, for the last half of a decade.
Perhaps their use have been doubled, maybe even tenfold, or even more in
that time. That still only accounts for a *very* small percentage of the
low-end systems we are targetting (it's not like we're aiming for 64-way
machines).

Of course we need to write the code to be correct in the presense of SMP,
but currently is we need to manually tune we should probably tune for one
CPU. At least on x86.

> Remember, Firebird is not just our toy - people use it for serious
> business.

Excuse me? Have I somehow given the impression I think of it as a toy?!

/Mike


_______________________________________________
Firebird-devel mailing list
Fir...@li...
http://lists.sourceforge.net/lists/listinfo/firebird-devel