[Original] self-built small software preliminary test access and SQLite database execution efficiency (C #)

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.