George Ionescu, dando pulos de alegria, escreveu :
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.
As you know, average (read) disk access times are between 10~15
miliseconds, so it's impossi
For a more useful test, please make a second table with 2 fields,
like Test but with a second VARCHAR(10) column. Then compare the
speed of inserting into that table vs inserting into your first one.
After all, if the problem is specific to single-column tables, then
we should get rid of all t
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
3 matches
Mail list logo
