Comment Performance : SAPDB rules (Score 1) 97
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
- 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
...)
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.