On Wed, May 27, 2009 at 08:05:00AM -0400, pyt...@bdurham.com wrote: > Dr. Hipp, > > > Your OS and filesystem configuration have a big impact too. I've notice, > > for example, that transactions are really slow on RieserFS on Linux > > compared to Ext3. > > In your experience, which Linux file system(s) provide the high > performance platform for SQLite?
I can't speak for DRH, but I have found that ext3 with the option of "data=journal" gives a massive improvement speed wise than default ext3 options, mainly because the journal is contiguous and ext3 can avoid seeks while still ensuring data is written safely to disk. This is a big win for rotating platter disks. I did an informal benchmark of various filesystem types on Linux (note this is 2 1/2 years ago) as part of an OSNews thread here: http://www.osnews.com/permalink?184137 I'd be interested in how ext4 compares to ext3. Perhaps an evening project beckons. > > Which Linux file systems do you recommend avoiding for SQLite use? Anything with FAT in the name... Plus, avoid NFS due to possible locking issus. > > Thank you, > Malcolm _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users