> Journal mode is WAL I believe in-memory database can't have journal mode WAL. So you compare completely different settings.
Pavel On Tue, Aug 9, 2011 at 5:15 AM, <sreekumar...@gmail.com> wrote: > > Journal mode is WAL > > > ------Original Message------ > From: Roger Binns > Sender: sqlite-users-boun...@sqlite.org > To: General Discussion of SQLite Database > ReplyTo: General Discussion of SQLite Database > Subject: Re: [sqlite] In memory v/s tmpfs > Sent: Aug 9, 2011 2:42 PM > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 08/08/2011 06:34 PM, sreekumar...@gmail.com wrote: >> From the point of view of performance, I expected similar performance , >> tmpfs being a little slower due to filesystem overhead. However, the >> operations on tmpfs was much slower than expected. > > Using tmpfs requires many kernel calls which is considerably more effort > than the occasional malloc call. Additionally files have to be locked, > journals made etc (you didn't mention your journal setting). > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAk5A+g0ACgkQmOOfHg372QTR8ACgqNeeuOxHRy7+hMH5RY/OAyV2 > Wq0AoMaSRtoFN4obCgmgHlpHthd9z5Zp > =pkJt > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > Sent from BlackBerry® on Airtel > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
