Re: [sqlite] sqlite_get_table performance problems

2006-03-08 Thread Rob Lohman
Hi, I suspect "your network" (solution) is to blame. The client probably needs to (re)connect to your server or (re-) authenticate etc. This can easily be tested by running the application and database on the same system. Is the first query does not take 2 seconds you have your answer. Keep in

RE: [sqlite] sqlite_get_table performance problems

2006-03-08 Thread Griggs, Donald
-Original Message- From: Patrik Svensson [mailto:[EMAIL PROTECTED] Subject: [sqlite] sqlite_get_table performance problems ... Can someone PLEASE PLEASE PLEASE help me? = Hi Patrik, The good folks on this list likely cannot hel

Re: [sqlite] sqlite_get_table performance problems

2006-03-08 Thread Jay Sprenkle
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 i