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

2015-03-31 Thread Rob van der Stel
- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf Sent: donderdag 26 maart 2015 2:29 To: General Discussion of SQLite Database Subject: Re: [sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

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

2015-03-26 Thread Don V Nielsen
This discussion, and you guys, are amazing. I am learning so much! On Wed, Mar 25, 2015 at 8:56 PM, Keith Medcalf wrote: > > On Wednesday, 25 March, 2015 10:42, Simon Slavin > said: > > >On 25 Mar 2015, at 1:47pm, Rob van der Stel < > RvanderStel at benelux.tokheim.com> wrote: > > >> One open

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

2015-03-25 Thread R.Smith
On 2015-03-25 03:47 PM, Rob van der Stel wrote: > One open issue for me remains however. Can I assume that the FlushFileBuffers > API that SQLite uses still causes cache to be written to disk even though the > 'automatic write-cache flushing' of Windows is turned off ? Depends what you mean:

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

2015-03-25 Thread Keith Medcalf
On Wednesday, 25 March, 2015 10:42, Simon Slavin said: >On 25 Mar 2015, at 1:47pm, Rob van der Stel benelux.tokheim.com> wrote: >> One open issue for me remains however. Can I assume that the >> FlushFileBuffers API that SQLite uses still causes cache to be >> written to disk even though the

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

2015-03-25 Thread Keith Medcalf
On Wednesday, 25 March, 2015 07:47, Rob van der Stel said: >The naming in WinXP and Win81 is such that a mistake is easily made, the >corresponding options are namely: > >a1) WinXP: 'Optimize for for performance' -- this corresponds to >a2) Win81: 'Enable write cache on the device' >

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

2015-03-25 Thread Simon Slavin
On 25 Mar 2015, at 1:47pm, Rob van der Stel wrote: > One open issue for me remains however. Can I assume that the FlushFileBuffers > API that SQLite uses still causes cache to be written to disk even though the > 'automatic write-cache flushing' of Windows is turned off ? I can't answer your

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

2015-03-25 Thread Rob van der Stel
Hello, I received several useful remarks and suggestions upon my post regarding the SQLite performance with Win8.1 + Intel RAID1. Especially the reminder that my fast System 1 (WinXP) was probably too fast for actual ACID made me look further into several cache options that windows and the