[sqlite] Very poor SQLite performance when using Win8.1 + Intel RAID1

2015-03-25 Thread Ketil Froyn
Have you checked the page/block/record size of the file systems and RAID systems, vs sqlite's page_size (which you can check or set with the relevant pragma: https://www.sqlite.org/pragma.html)? If sqlite has a smaller or different page size than the underlying storage, a single sqlite write can r

[sqlite] Very poor SQLite performance when using Win8.1 + Intel RAID1

2015-03-25 Thread Simon Slavin
On 25 Mar 2015, at 12:45am, Keith Medcalf wrote: > I don't know what sort of device cache your devices have, or whether it is > volatile or not. You would have to check with the manufacturer to see how > these settings (assuming they are available) affect the actual writing to the > non-vola

[sqlite] Very poor SQLite performance when using Win8.1 + Intel RAID1

2015-03-24 Thread R.Smith
On 2015-03-24 05:43 PM, Rob van der Stel wrote: > Hello, > > Currently I am investigating a SQLite performance problem that started to > occur when we switched from using Windows XP to Windows 8.1 for our > applications. > The following information is obtained to comparing two hardware identic

[sqlite] Very poor SQLite performance when using Win8.1 + Intel RAID1

2015-03-24 Thread Keith Medcalf
l >Sent: Tuesday, 24 March, 2015 09:44 >To: sqlite-users at mailinglists.sqlite.org >Subject: [sqlite] Very poor SQLite performance when using Win8.1 + Intel >RAID1 > >Hello, > >Currently I am investigating a SQLite performance problem that started to >occur when we switched f

[sqlite] Very poor SQLite performance when using Win8.1 + Intel RAID1

2015-03-24 Thread Rob van der Stel
Hello, Currently I am investigating a SQLite performance problem that started to occur when we switched from using Windows XP to Windows 8.1 for our applications. The following information is obtained to comparing two hardware identical systems one running Win XP the other running Win 8.1. ***

[sqlite] Very poor SQLite performance when using Win8.1 + Intel RAID1

2015-03-24 Thread Simon Slavin
On 24 Mar 2015, at 3:43pm, Rob van der Stel wrote: > Samsung 128 GB SSD Are those Samsung 830s ? Those things are insanely fast. FlushFileBuffers() does all the hard work in disk access. Other calls may end up changing only cached information whereas FlushFileBuffers() has to go mess with

[sqlite] Very poor SQLite performance when using Win8.1 + Intel RAID1

2015-03-24 Thread Jeremy Nicoll - ml sqlite users
Rob van der Stel wrote: >Hello, > > Currently I am investigating a SQLite performance problem that started to > occur when we switched from using Windows XP to Windows 8.1 for our > applications. I don't know anything about SQLite, but faced with what you're seeing I think I'd want to be sure h