Re: [sqlite] Answer to Linux vs Windows performance issues

2005-05-18 Thread Doug Henry
It gets worse when you throw in journaled file systems. The problem linux faces is there are many filesystems you can pick, so the kernel/system needs to be a bit wishy-washy and leave some implementation details up to other codes. I think if your using ext3 (in data=journal and data=ordered

[sqlite] Answer to Linux vs Windows performance issues

2005-05-18 Thread Ludvig Strigeus
Stuff below relates to IDE drives. On Linux, the fsync() call doesn't actually force that the data reaches the physical disk platters. It just makes sure that the data is sent to the cache on the disk. On Windows, FlushFileBuffers() forces the disk to actually write the data to the physical