On Thu, Oct 18, 2012 at 1:57 PM, Paxdo Presse <pa...@mac.com> wrote: > > Hello, > > in FAQ http://www.sqlite.org/faq.html : > > "Actually, SQLite will easily do 50,000 or more INSERT statements per > second on an average desktop computer. But it will only do a few dozen > transactions per second. Transaction speed is limited by the rotational > speed of your disk drive. A transaction normally requires two complete > rotations of the disk platter, which on a 7200RPM disk drive limits you to > about 60 transactions per second." > > When a transaction only *reads* finally, as below, will it need to do two > complete rotations of the disk platter, as described above? >
No. Only write transactions. > > > - begin transaction > - select.... > - select... > - end transaction > > > thank you, > olivier > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
