Are you using SQLite that is built into PHP5? That SQLite version is 2.8.17, or at least it is on my pc. Anyway, you might want to consider switching to a newer version of SQLite and using PHP's PDO functions which will allow you to connect to a SQLite3 database.
In my application, I experienced a dramatic increase in speed by switching to version 3.2.8. -----Original Message----- From: Laurent Goussard [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 12:05 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite to MySQL I don't know, I suppose my queries are not as optimized as I thought (even if this optimization was my leitmotiv for all the development part), or perhaps it's an apache2+php5 issue on my windows computer... But the fact is since the database has grown (like my traffic : 6000 visitors/day and 22Mb db file), I've got more and more "maximum execution time" errors at the peak hours. I've monitored them, and it seems a lot of simultaneous queries are freezing the server and finally generates this error. The interresting point is the same queries sent a testing mysql db while the sqlite part is not responding anymore are working very well, So that's the reason why I consider to switch on a mysql solution for this website. Do you got clues concerning conversion ? 2006/2/6, Jay Sprenkle <[EMAIL PROTECTED]>: > > Hi there, > > > > I use SQLite on my website for 2 years now. I do like SQLite a lot and > > will use it for a lot of new web projects but, because I got more and > > more traffic, I consider to move this one to MySQL in order to reduce > > the over load of my computer (I host it @ home). > > How is this going to reduce load? > > sqlite = mysql - server code > > You're adding server code. More code = More load. >
