[sqlite] Find out how many times does SQLite hit the disk?

2016-02-01 Thread Rowan Worth
On 31 January 2016 at 15:09, Yannick Duch?ne wrote: > If it's memory mapped, it's less an efficiency issue, > Hm, can you elaborate on this assertion? I don't think I agree. Lets say sqlite wants to access a page in the DB/journal. In the case of normal file access this is a call to pread/ReadF

[sqlite] Find out how many times does SQLite hit the disk?

2016-01-31 Thread James K. Lowden
On Sun, 31 Jan 2016 03:01:30 +0530 dpb wrote: > 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. I second Simon's question. If SQLite isn't fast enough, a good starting assumption is

[sqlite] Find out how many times does SQLite hit the disk?

2016-01-31 Thread Dominique Pellé
dpb 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. > >

[sqlite] Find out how many times does SQLite hit the disk?

2016-01-31 Thread Yannick Duchêne
On Sat, 30 Jan 2016 20:36:55 -0800 J Decker wrote: > On Sat, Jan 30, 2016 at 8:09 PM, J Decker 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=-21472173

[sqlite] Find out how many times does SQLite hit the disk?

2016-01-31 Thread dpb
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

[sqlite] Find out how many times does SQLite hit the disk?

2016-01-30 Thread Simon Slavin
On 30 Jan 2016, at 9:31pm, dpb 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 w

[sqlite] Find out how many times does SQLite hit the disk?

2016-01-30 Thread J Decker
On Sat, Jan 30, 2016 at 8:09 PM, J Decker 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 memor

[sqlite] Find out how many times does SQLite hit the disk?

2016-01-30 Thread J Decker
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 wrote: > > On 30 Jan 2016, at 9:31pm, dpb wrote: > >> On windows,