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
