could use a tool like ProcMon and filter to disk activity on a specified file to see... https://technet.microsoft.com/en-us/sysinternals/processmonitor.aspx?f=255&MSPPError=-2147217396
On Sat, Jan 30, 2016 at 3:21 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 30 Jan 2016, at 9:31pm, dpb <dpb795795 at gmail.com> wrote: > >> 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. > > You will find that tools which examine process statistics will tell you how > many read and write operations the process does. > > To do it in SQLite you might add your own code to the standard VFS for your > OS just to total up accesses to disk. > > <https://www.sqlite.org/vfs.html> > > However, I am not certain that counting disk accesses is actually going to > help you figure anything one. > >> I am done with adding indexes to my tables in >> SQLite DB. > > Are you sure you're adding the /right/ indexes ? I see many people adding > indexes to commonly-used columns without making up a index designed > specifically to help a particular SELECT command. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users