On Thu, Nov 12, 2009 at 11:24:58AM -0600, Bret Patterson wrote
> We're seeing a lot more disk activity than expected on Linux when
> using sqlite3. We've run this same series of test on windows and
> the disk IO is much lower, which is the opposite of what I really
> expected. Below is my scenario and perhaps someone can point out
> what I can do to fix this problem.
Since it seems to be a linux issue, what are the mount settings for
the partitions? This may seem obvious, so please don't take this as an
insult. Here goes...
- "noatime" (for all file systems) will reduce disk I/O and speed
things up
- if using ReiserFS, use the "notail" option
- the default is that all filesystems are mounted async, but check to
make sure
Then there are the hard drives. Use the hdparm utility to confirm
that DMA is turned on.
I assume the linux machine is a server, running in text mode, rather
than a resource-heavy GUI.
--
Walter Dnes <waltd...@waltdnes.org>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
