Hello sqlite users, Hello Dr. Hipp,
while using sqlite v3.0.6, I've discovered that doing a single INSERT or UPDATE on a table which has only one field is very slow:
CREATE TABLE Test (Field1 VARCHAR(10));
INSERT INTO Test VALUES ('123');the INSERT statement above takes approx. 150 milliseconds to complete, which is very slow compared to Access/ADO, which does the same in 3 milliseconds.
The timings were done on a 2.4 Celeron, 512 RAM, Windows XP.
Is there something I'm missing here or is this the expected behavior? Timings on other operations (SELECT) yielded expected results (e.g. faster than Access/ADO).
Best regards, George Ionescu
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
