MySQL should be avoided like the plague. Use Postgres instead if you have to switch to a larger SQL DBMS. But hopefully the help you've gotten so far will extend your mileage with SQLite and you won't have to switch to anything yet. -- Darren Duncan
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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
