Perfect, thank you M. Hipp!

Le 18 oct. 2012 à 20:32, Richard Hipp <d...@sqlite.org> a écrit :

> 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

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

Reply via email to