You have created a small software to test the efficiency of access and SQLite databases in database creation, data table creation, and new record addition. SQLite execution efficiency is high.
Is an image of my gadgets:
On my computer, just now, I made the following test results:
Use the ACCESS database,
It takes 31.0262 milliseconds to create a database
It takes 146.9988 milliseconds to create a data table newtable.
It takes 37.9294 milliseconds to add 1 record
It takes 52.2736 milliseconds to add 10 records
Adding 100 records takes 181.9647 milliseconds
Adding 1000 records takes 1621.2004 milliseconds
Adding 10000 records takes 16237.5385 milliseconds
Using the SQLite database,
It takes 48.7232 milliseconds to create a database
It takes 63.463 ms to create a data table
It takes 8.0529 milliseconds to add one record!
It takes 5.3238 milliseconds to add 10 records!
It takes 100 milliseconds to add 18.6934 records!
It takes 1000 milliseconds to add 143.6959 records!
It takes 10000 milliseconds to add 1241.6164 records!
It takes 100000 milliseconds to add 13354.0528 records!
As shown above, when a large number of new records are added, the SQLite database requires less time and higher execution efficiency.
The following tool is created by me. Please download and test it. If you have any questions, please send me an email or leave a message. Cnhyke (AT) 126.com
/Files/yelsea/mdb_sqlite_compare.rar