Subject Re: information
Author Roman Rokytskyy
Hi,

> Somebody saw comparaisons of productivity for SAP DB and others
> RDBMS? or somebody do comparaisons?

You will not get comparisons of any commercial DB because publishing
such results is prohibited by a license (at least by Oracle, IBM and
Borland). So the only thing you can do is to measure it yourself.

SAP DB... Some time ago I did a comparison of Firebird, JDataStore,
SAP DB, PostgreSQL and few others with queries I need in my
application, and SAP DB died without saying anything after ~70,000
inserts in one transaction (during test initialization). This is not
very usefull test, but I will not use the database that simply dies.
My transaction can die, but not the database server. BTW, Firebird
was fine with this bulk insert (however, commit took some time).

The fastest DB was JDataStore in embedded mode (server runs in the
same JVM with application), then Firebird on the remote server,
Firebird on localhost and then others. Note, I measured only queries
that were interesting to me, so this is not generic.

Best regards,
Roman Rokytskyy