Firebird adds new features with version 2.1

Posted May 29, 2008 4:50 UTC (Thu) by jobinau (guest, #52296)
In reply to: Firebird adds new features with version 2.1 by intgr
Parent article: Firebird adds new features with version 2.1

>>Meanwhile MySQL and PostgreSQL are making all the headlines.
yes they are making much noice. but still lagging.

Mysql is still under development. far behind a matured RDBMS.
Postgress is still stucked up in Processes instead of threads. but other than heavy on
resources, Postgres is a OK.

Firebird is real winner.

to post comments

Firebird adds new features with version 2.1

Posted May 29, 2008 12:09 UTC (Thu) by nix (subscriber, #2304) [Link]

I suspect you don't know what you're talking about.

Using processes instead of threads doesn't necessarily make you 'heavy on 
resources'. It doesn't necessarily indicate that you are 'stuck' in any 
way at all. It requires greater discipline than using threads, and the 
context switch time is slightly higher, making it an inappropriate 
technique for insane loads, but in every other way using processes is 
*preferable*.

Think: what happens if a single MySQL server thread crashes. Who knows 
what state it corrupted first: best take the whole server down.

If a PostgreSQL server crashes, the others are unaffected, their address 
spaces inviolate save for a strictly-defined shared memory region: they 
can generally carry on.