I did some performance testing of our application with some databases (on linux, via unixODBC); a mixture of selects, inserts and deletes.
here my (absolutely unscientific) ranking:
SAPDB
Firebird
PostgreSQL
remarks:
All three databases performed well
(RANT: It is a nuissance that there is no standard for called procedures!)
SAPDB was almost twice as fast on inserts as PostgreSQL (deletes where only a little faster)
Firebird: somewhat slower than SAPDB. I didn't know then that there are also some tuning possibilities.
MySQL: I didn't even test it because it isn't ACID (I know, there are recent additions, but...)
we have been using sapdb now for half a year and it rocks!
Of course it is heavier than the other databases; and it is a little hard to get started. (The beginners documentation could be better, although there are web sites providing valuable hints)
Would I recommend it for medium or big sized installations? Yes, without hesitation.
Slashdot Mirror
here my (absolutely unscientific) ranking:
- SAPDB
- Firebird
- PostgreSQL
remarks:- All three databases performed well
- (RANT: It is a nuissance that there is no standard for called procedures!)
- SAPDB was almost twice as fast on inserts as PostgreSQL (deletes where only a little faster)
- Firebird: somewhat slower than SAPDB. I didn't know then that there are also some tuning possibilities.
- MySQL: I didn't even test it because it isn't ACID (I know, there are recent additions, but
...)
we have been using sapdb now for half a year and it rocks!Of course it is heavier than the other databases; and it is a little hard to get started. (The beginners documentation could be better, although there are web sites providing valuable hints)
Would I recommend it for medium or big sized installations?
Yes, without hesitation.