On Sat, Jan 30, 2016 at 8:09 PM, J Decker <d3ck0r at gmail.com> wrote: > 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
Might not actually be useful though; if the file is memory mapped (WAL Journal?) then you won't see those accesses... then you'd end up having to hook into VFS stuff... > > 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
