To compare the performance of MySQL vs SQLite, a quick sample database was made based off of a previous PingER SQL database schema. Existing converted data was available based on PingER results from December, 2001.
The shell time
command is used below to measure the amount of processing involved with each task. Unfortunately, it cannot capture the CPU use of the MySQL daemon processes that are handling the other end of the client-server connection. Elapsed time must be used to estimate run time. The machine being used for testing was not being used for anything else at the time the tests were run.
Table structure
MySQL table structure
...
MySQL's elapsed time was actually longer than SQLite. The shell time
command does not capture the CPU use of the MySQL daemon processes that are handling the client-server connectivity.
Sample insert data for data_200112 table
...