We are happy with the results using JFS on AIX and SUSE Linux.  Also no 
concerns with EXT3 on various Linuxes.  We have learned to avoid Windows.

Christian Smith wrote:
> On Wed, May 27, 2009 at 08:05:00AM -0400, pyt...@bdurham.com wrote:
>   
>>
>> 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.
>>
>>     

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to