how to retrieve 100000 record from sqlite (Mobile Applications) ????!!!!!!!

[Yajjoj]

please help me with this...... i am trying to read more than 100000 record from my SQLite database very fast. At the moment it takes 40-45 second to perform a select on the last record. Does anybody knows the code for vb.net compact framework, to perform this search in less than 5 or 10 seconds? :wtf:

al hajjaj

[Not Active]

It's not question of the .net code, it's a question of how the data is structured and queried. Are you trying to use any complex joins? Do you have covering indexes? Do you really need to retrieve all 100000 at once? This seems extremely excessive for a mobile application.

---

I know the language. I've read a book. - _Madmatt