We use MySQL on a fairly high end PC server running Linux. The database is about 300-400 gigs. Front end of PHP and apache. It's been reliable for a couple years now and seems to have a bunch of headroom. I wrote a wrapper so my SQLite code (with minor modification) can feed MySQL instead of SQlite. In fact, the thing that feeds the MySQL DB reads Sqlite DB's and then feeds this data into MySQL every 15 minutes or so.
I'd have no problem recommending MySQL for mission critical uses. Postgres might be better but, MySQL's been good enough. C Friday, June 3, 2011, 2:19:44 PM, you wrote: DD> MySQL should be avoided like the plague. Use Postgres instead if you have to DD> switch to a larger SQL DBMS. But hopefully the help you've gotten so far will DD> extend your mileage with SQLite and you won't have to switch to anything yet. -- DD> Darren Duncan DD> Ian Hardingham wrote: >> Guys, the server for this game - >> >> http://www.frozensynapse.com >> >> uses SQLite. We've had an unexpectedly successful launch which has >> resulted in the server being swamped with players, and I'm trying to >> optimise everywhere I can. I've always been under the impression that >> SQLite is pefectly fast and it's the scripting language I wrote the >> server in which is too blame. (Yes, I know writing a back-end in a >> single-threaded scripting language is an absolutely terrible idea). >> However, everyone in the industry I talk to says that SQLite must be one >> of the problems. >> >> I may be looking at a complete re-write. I may also need to have a >> solution which scales beyond one machine. Can anyone give me advice on >> this matter specifically? >> >> (The video on that website at 2.04 gives a good idea of what kind of >> functions are being powered by the database). >> >> Thanks, >> Ian DD> _______________________________________________ DD> sqlite-users mailing list DD> sqlite-users@sqlite.org DD> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users