Hi Jason, My concern is scalability and the performance hit of having let's say 5000
users potentially, accessing 5000 databases at the same time on the server. Based on my readings around the web there are ways to optimize sql queries (transactions, in memory dbs and all that) but even with that, would it be feasible or better yet advisable?
If you need a do something that like what you have described. You are better of using a full blown database server, like Postgresql or even MySQL. I'm not saying those are the only ones, but in your case your better off using one. Sqlite is great and all, but in your case as I have said would be far more trouble than its worth. Sincerely, Paul
