CSQL Wisconsin Benchmark Results
Benchmark results of CSQL for database operations which application performs
80% of the time. This benchmark is based on wisconsin benchmark which contains real time queries and
database operations.
Machine Configuration: These tests were performed on normal desktop machine,
Dell loaded with 1GB RAM on Linux 2.6 Kernel
Wisconsin Benchmark schema having tables 'big1' and 'big2' with 10K records each and 'small' table with 1K records.
Tests are performed after caching all records in memory for leading database management system.
Interface used: JDBC
Benchmark Operations
| Statement Type | Statement Executed |
| SelectInt | SELECT unique1, unique2, stringu1, stringu2 from big1 where unique1=?; |
| SelectStr | SELECT unique1, unique2, stringu1, stringu2 from big1 where stringu1=? |
| Select-100 | SELECT unique1, unique2, stringu1 from big1 where unique1 between ? and ? |
| Insert | insert into big1
values(?,?,0,2,0,10,50,688,1950,4950,9950,1,100, 'MXXXXXXXXXXXXXXXXXXXXXXXXXGXXXXXXXXXXXXXXXXXXXXXXXXC', 'GXXXXXXXXXXXXXXXXXXXXXXXXXCXXXXXXXXXXXXXXXXXXXXXXXXA', 'OXXXXXXXXXXXXXXXXXXXXXXXXXOXXXXXXXXXXXXXXXXXXXXXXXXO') |
| Update | UPDATE big1 SET two=1 WHERE unique1=? |
| Delete | DELETE FROM big1 WHERE unique1=? |
| Join 10K * 1K |
SELECT big1.unique1, big1.unique2,
small.unique1, small.stringu1 FROM small,big1 WHERE big1.unique1=small.unique1 AND small.unique1=? |
| Join 10K * 10K |
SELECT small.unique1, big1.unique1,
big2.unique1, small.stringu1, big1.unique2, big2.unique2 FROM big1, big2, small WHERE small.unique1=big1.unique1 AND big1.unique1=big2.unique1 AND big1.unique1 = ? |
CSQL MMDB Wisconsin Benchmark Results
For the above said operations, time taken is measured in microsecond for leading traditional database system and for CSQL Main Memory Database System. The benchmarking application and the database server runs in the same machine/host and table fully cached in RAM during the test.
Leading DB |
CSQL |
Times Faster |
|||||||
| Statement Type | No Index |
Hash Index |
Tree Index |
No Index |
Hash Index |
Tree Index |
No Index |
Hash Index |
Tree Index |
| SelectInt | 6097 | 331 | 325 | 247 | 11 | 11 | 24.68 | 30.09 | 29.55 |
| SelectStr | 6495 | 979 | 356 | 286 | 16 | 15 | 22.71 | 61.19 | 23.73 |
| Select-100 | 6861 | NA | 826 | 508 | NA | 120 | 13.51 | NA | 6.88 |
| Insert | 218 | 265 | 213 | 20 | 13 | 11 | 10.90 | 20.38 | 19.36 |
| Update | 5572 | 217 | 188 | 473 | 14 | 12 | 11.78 | 15.50 | 15.67 |
| Delete | 5741 | 200 | 168 | 573 | 15 | 13 | 10.02 | 13.33 | 12.92 |
| Join 10K * 1K | 6459 | 320 | 292 | 35 | 11 | 11 | 184.54 | 29.09 | 26.55 |
| Join 10K * 10K | 14916 | 411 | 320 | 36 | 13 | 14 | 414.33 | 31.62 | 22.86 |
CSQL Vs Leading DBMS
From the above results, it is evident that CSQL is approximately 30 times faster than leading database with standard JDBC interface for real time database operations. This demonstrates CSQL's ability to meet the most demanding service levels which traditional disk based database systems cannot deliver.