SQLite Forum

Performance decrease over-time using SELECT
Login
You didn't mention what programming language and interface library you are
using to access SQLite.  My initial guess (based on very little information)
is that the problem is in the interface to your programming language of choice,
and not in SQLite itself.

Can you provide complete code so that we can reproduce your problem and
hence chase it to ground?