On 3/8/06, Patrik Svensson <[EMAIL PROTECTED]> wrote: > Hi, > > I have BIG BIG problems with my database (sqlite2). > > I have a 50Mb database located on a server. > From my client I run a quite large select statement using the > sqlite_get_table function. > > The first time this select is issued it takes about 2 minutes to get the > result. > If I run the same select again it will take approx 1 second. > Then after a while it suddenly can take 2 minutes again. > > I guess this must be some caching problem but I'm stuck and 2 minutes is NOT > acceptable even for the first select.
have you looked at the indexes to see if they're correct for the query you're running?
