Hello all,
I've been playing around with sqlite for the past while, and am thinking of using it in a upcoming project.
I have a few questions, if anyone is able to offer some insight.
What happens when a database file is opened? Is the structure & indexes of all the tables read into memory? Is there any benefit in grouping tables in different files? For instance, we have user tables that get used regularly, and stats tables that grow daily, yet much of the information over 30 days old is rarely used. Is it recommended we store this in an archive database, or is there no affect on resources till the table is actually called on.
We are currently using mysql. What is the comparison to opening a database with sqlite vs connecting to the daemon with mysql? Our current box has seen 300+ connections to the sql server at at once. Can we expect that having 300 databases open with sqlite wont be a problem?
And finally, is there any more news on sqlite3 for php5?
Regards, -Jason
