C # inefficient access to sqllite Databases

Source: Internet
Author: User
When I changed the database of a project from SQL Server 2005 to the sqllite database yesterday, I found that the database read and write speed had become surprisingly slow, the original transaction processing in SQL Server 2005 may be completed in 1 s, but it takes 5 or 6 s to access sqllite. However, the database structure in sqllite is the same as that in SQL Server, but the database access layer accessing SQL Server 2005 has been slightly changed. All database access statements are also very simple. The table structure of the database is also very simple. Generally, there are about 10 fields in a table. Currently, the data volume of the database is not large, just a few hundred pieces of data, the operations we perform are query, insert, and delete, and optimize the use of SQL as much as possible. This is generally a single table operation, and also avoids the use of select
* For the from search, table join also uses inner join. It seems strange. Please give me some advice when investigating the cause.

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.