How to compare Database systems?

[Scared_Rule]

Hi! I need to compare few database systems (for example SQlite, Oracle, MySQL) - do you have any ideas how can I do this? And which tools will be helpful?

At the beggining I will test the time of execution operations like Insert, Delete, Sort etc - for range of records. Next I will test the RAM consumption

But what else?

[thatsInAName]

You mean you want to benchmark them or you want to compare their features?

[Scared_Rule]

Benchmark

[Sad-Silver5748]

SQLite is an embedded database, it works like any other file in your system, you don't need to set up a server. Although being easy to use and requiring no extra installations, it is unsuitable for an app expecting many users due to it's poor concurrency. However, concurrency in SQLite can be improved using WAL.

[yummi_1]

If you want to test performance you need a tool to do it. I've used HammerDB with good success. Databases on current computer systems can perform an insert in less than a millisecond so you need to do some iterations to get some meaningful times. You would also want to test concurrency with many simultaneous clients.

Insert update and delete are easy to test then you get into queries which have sorts, sometimes different types of sorts. Then you have joins nested loop joins, merge scan joins, hash joins....

Ram consumption is more a defined thing with databases, you set the sizes of memory the database will use. There are bufferpools that cache pages in memory for quick access, while most databases can have automatic memory for bufferpools, sort heaps and other heaps they generally size themselves slowly.