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 mind that SQLite is not a client-server system,
it is more like an embedded database system.
To me it feels like you are trying to use a product in a
way it was not designed and I would expect problems
like these from that.
Good luck,
Rob
----- Original Message -----
From: "Patrik Svensson" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, March 08, 2006 2:40 PM
Subject: [sqlite] sqlite_get_table performance problems
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.
Can someone PLEASE PLEASE PLEASE help me?
Cheers,
Patrik
