dpb <dpb795795 at gmail.com> wrote: > Dear SQLite Community, > > On windows, is there a way to find out how many times does my SQLite DB hit > the disk? > > This will help me in deciding if moving to In-memory SQLite will improve my > application performance. I am done with adding indexes to my tables in > SQLite DB. > > If possible, please point me URLs that will help me.
You could print the number of SQLite page misses. Each miss causes an I/O of page size bytes. See sqlite3_db_status(): https://www.sqlite.org/c3ref/db_status.html https://www.sqlite.org/c3ref/c_dbstatus_options.html On Linux, I would also use strace to see I/Os. I suppose that procmon on Windows can also show I/Os. Regards Dominique
