SQLite 3.7.5.
I have a table (13 columns with 1 primary key, 1 index on a date column, 1
UNIQUE-constraint on two columns).
I insert ~1300000 rows, 1000 at a time (transaction-wise).
I close the database, reopen it and immediately perform a COUNT-operation:
SELECT COUNT(ItemID) FROM Items;
This takes around 40 seconds the first time! WHY?!
I believe the value is somehow cached inside the database after the above call.
The table used:
CREATE TABLE IF NOT EXISTS Item
(
ItemID INTEGER PRIMARY KEY,
A INTEGER NOT NULL,
B INTEGER NOT NULL,
C INTEGER NOT NULL,
D INTEGER NOT NULL,
E INTEGER NOT NULL,
F INTEGER NOT NULL,
G INTEGER NOT NULL,
H DATE NOT NULL,
I CHAR(3) NOT NULL,
J INTEGER NOT NULL,
K INTEGER NOT NULL,
L INTEGER NOT NULL,
UNIQUE (B, A)
);
CREATE INDEX IF NOT EXISTS Item_H_Index ON Item (H);
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
