Are you using any BLOBs in your table?. More often than not it will be your
query which will have direct impact on the performance. I suggest you to
check that appropriate columns have been indexed and are used in right
manner as specified in the SQLite documentation or mailing list with subject
"
Hey all,
i've an SQLite 3 database coming from a mobile phone (e2831) which
works well on the phone itself :
BEGIN TRANSACTION;
CREATE TABLE devicephonebook( UID INTEGER PRIMARY KEY
AUTOINCREMENT ,lastName TEXT NOT NULL DEFAULT(''),firstName TEXT
NOT NULL DEFAULT(''), lastChar INTEGER
The attached patch implements the compound (multi-row) INSERT statement
syntax against the SQLite 3.5.1 source tree. Both named and unnamed
INSERT column syntax with DEFAULT column values are supported.
The patch transforms multi-row INSERT statements into compound SELECT
statements separated by
3 matches
Mail list logo