Issues related to SQLLite Index

Question

Hi All:

We are using SQLite database to store data. We are having a very peculiar situation. Let me summarize

1. Database having multiple tables.
2. Tables having 3000 rows.
3. Tables are having index.
4. There is considerable gain due to indexes.
5. When I run the application and access certain data the query runs slow.
6. But if I just open the database in Black Cat SQLite editor, suddenly the queries becomes fast.

We are running the index queries everytime the application starts, also the sync=off.

Regards Debasish