[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