| 
| 
66666; text-align: left; width: 695px; padding: 0px;">Why Select Lava Distributed SQL?
Database Comparison
Below is a table of comparison for three of the most popular databases. We have tried to be as fair as possible, and have included a wide range of important attributes in the comparison - including some where the Lava system does not outperform its competitors. No database can be the best at absolutely everything.
If you believe we have erred with regard to a particular characteristic, let us know (please provide substantiation) and we will correct the table.
If there is an attribute or performance benchmark you would wish to see in the table, contact us and we will endeavor to include it.
|
|
MySQL |
SQL Server |
Oracle |
Lava Distributed SQL |
|
Enterprise cost |
$12,000 per annum (full version including replication server) |
$14,000 (25 users) or $24,000 per processor (i.e. minimum of $96,000) |
$9,500 per processor per annum (i.e. minimum of $38,000 per annum) |
Typical cost $10,000 per annum, any number of processors, including Blueprint, standby server and satellite servers (note that Microsoft and Oracle costs do not include development system, replication server, distributed servers) |
|
Maximum practical size of tables (powerful server) |
500 M rows |
250 M rows |
2B rows |
2B rows |
|
Maximum data insertion rate |
1,000 rows per second |
500 rows per second |
2,000 rows per second |
20,000 rows per second |
|
SQL support |
very good |
excellent |
excellent |
good |
|
Administration |
Easy |
Reasonably easy |
Difficult |
Easy |
|
Backup / Restore |
Ok but very slow |
Good |
Difficult |
Excellent |
|
Integrated programming language |
Very poor - only for simple stored procedures and triggers |
Moderate |
PL/SQL, quite powerful but only for stored procedures and triggers |
LavaStream - Excellent integration, both for stored procedures and general programming |
|
Processing Efficiency |
Good |
Poor |
Moderate |
Excellent |
|
3GL API |
Moderately good |
Moderately good |
Poor |
Excellent |
|
Database interfaces |
ODBC, JDBC, ADO, MySQL API |
ODBC, JDBC, ADO, API |
ODBC, JDBC, ADO |
ODBC, Lava API |
|
Distributed Server |
No |
Yes |
Yes |
Yes |
|
Distributed Client |
No |
No |
No |
Yes |
|
Integrated Workgroup Client |
No |
No |
No |
Yes |
|
Grid Servers |
No |
No |
Yes |
Partial |
|
Entity-Relation design support |
None |
Good |
Good |
Very good |
|
Programming environment |
None |
Good |
Average |
Excellent |
|
Workgroup development |
No |
No |
No |
Comprehensive |
|
Application exclusive mount |
No |
No |
No |
Yes - performance improvement by 300% |
|
Database (installable) size |
Moderate |
Large |
Very large |
Small |
|
Hardware cost (very large database or high transaction rate) |
Moderate ($3,000) |
Very high. Very difficult to configure hardware to meet requirements |
High ($10,000 or more) |
Low ($1,500 or less)
|
|
Data import from other databases |
No facility - only custom programming |
Slow and clumsy import package |
Difficult to use |
Powerful and fast semi-automated import facilities |