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? - 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
