Which is the fastest way to retrive all items in SQLite?
- by sxingfeng
I am programming on windows, I store my infors into sqlite.
However I find to get all items is a bit slow.
I am using the following way:
select * from XXX;
retriving all items in 1.7M SQLite DB takes about 200-400ms,
It is too slow. Can Anyone Help!
Many Thanks!