During this test, every hit involved multiple SELECTs and at least one UPDATE against a single sqlite database file. The database engine was easily able to handle a rate of over 2500000 (2.5M) hits/day or about 30 hits/second. The database did not appear to be the limiting factor in this test - other components (such as the customized web server that www.sqlite.org uses and the exec()-ing of RCS commands) seemed to be what kept it from going even faster.
Can you tell us what hardware this was on?
Athlon 1600. 1GB RAM. 5400RPM IDE disk. Redhat 7.3
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
