SQLite Forum

SQlite Speed
Login
Hello All

I have a table defined as follows:

"ID"	INTEGER PRIMARY KEY AUTOINCREMENT,
"Name"	TEXT,
"Cat"	TEXT,
"LData"	BLOB

In my android app when I try to open this table it takes almose 5 or 6 seconds to load this data into a Memo in Delphi XE7 Firemonkey.  The are about 650 records in this table.

I tried creatinf a different table with obly the BLOB field in it linked to this table by ID.

It doesnt improve matters.

Any sugestions kn how I can speed up this table?

Regards
Abin