[Opensim-users] SQLite vs MySQL - any big difference?

Dr Scofield DrScofield at xyzzyxyzzy.net
Thu Jul 9 06:48:35 UTC 2009


Justin Clark-Casey wrote:
> Robert Klein wrote:
>> What are the absolute key advantages or disadvantages to using SQLite vs
>> MySQL for OpenSim?
> 
> afaik, SQLite is generally better for single user low-load applications, while MySQL is better for high load multi-user 
> ones.
> 
> In OpenSim this would translate to SQLite being fine for single user standalones (such as sandboxes), with MySQL being 
> worth the setup hassle for anything beyond that.
> 

+100 on that.

private sandbox (development, proof-of-concept stuff): sqlite is fine
anything else: mysql (or the other DBs, though i've got no experience with those)

	cheers,
	DrS/dirk

-- 
dr dirk husemann ---- virtual worlds research ---- ibm zurich research lab
SL: dr scofield ---- drscofield at xyzzyxyzzy.net ---- http://xyzzyxyzzy.net/
RL: hud at zurich.ibm.com - +41 44 724 8573 - http://www.zurich.ibm.com/~hud/



More information about the Opensim-users mailing list