SQLite Forum

Slow select operation after many times of insert different Table
Login
Various posters to this thread have excellently covered the amount of time taken by software.  You asked about a difference between the amount of time your computer took, and the amount of time one of the responder's computers took.

SQLite is fast and efficient and most of the time it takes is taken in storage access – reading and writing files.  If two computers execute SQLite APIs at different speeds the cause is usually hardware *operating as designed*.  This is taken up by, among other things,

* speed of storage (hard disk rotation speed, spinning rust or SSD)
* number and sizes of caches (application cache, OS cache, storage subsystem cache)
* whether other apps are accessing storage, thus busting the caches
* how much CPU the database app is able to use (what other processes are doing)
* how efficient the OS is at handing the database app's requirements

As an example, a recent bug in Lenovo's System Update application for Windows, which runs in the background, caused it to use 6% of available CPU in a typical windows installation all the time the computer is working.  You wouldn't find this problem by profiling your database program.

So don't worry if someone else's computer is faster than yours.  Unless your computer isn't working fast enough to make your program useful, in which case use a dedicated computer with a simple OS and storage setup.