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

Wordfromthe Wise drwhiet at spacefriends.de
Mon Jul 6 21:59:33 UTC 2009


i also see faster startup times on my standalones. And also visible faster
rezzing of prims inworld .. 

and here is a test with one of my sims .. bit done by the "landlord" ... 
http://www.maxping.org/resources/how-to/maintain-regions/moving-a-sim-from-s
qlite-to-mysql.aspx


best regards
Wordfromthe Wise

-----Ursprüngliche Nachricht-----
Von: opensim-users-bounces at lists.berlios.de
[mailto:opensim-users-bounces at lists.berlios.de] Im Auftrag von Chris Hart
Gesendet: Montag, 6. Juli 2009 23:07
An: opensim-users at lists.berlios.de
Betreff: Re: [Opensim-users] SQLite vs MySQL - any big difference?

MSSQL works very well too (and Express edition is free for databases up to
4Gb). While it's not officially supported by core devs to the same extent as
MySQL, those of us who use it are avid patchers and keep the MSSQL side
up-to-date. As far as OpenSim is concerned, you can use it for standalone,
but SQLite is extremely simple out of the box for a basic standalone. It's a
solid alternative to MySQL.

Chris


-----Original Message-----
From: opensim-users-bounces at lists.berlios.de
[mailto:opensim-users-bounces at lists.berlios.de] On Behalf Of Tim Allen
Sent: 06 July 2009 21:26
To: opensim-users at lists.berlios.de
Subject: Re: [Opensim-users] SQLite vs MySQL - any big difference?

It is funny to see MySQL being described as the more robust solution, when
some (very uninformed) people still call it a 'toy database' - which was
sort of true in 1999, but not 2009. In 2009, MySQL is an extremely robust,
high-performance, high-reliability database that scales quite nicely. I'd
highly recommend it over SQLite for any kind of reliability, but as
mentioned before, for single-user sandboxes, SQLite may be easier out of the
box.
_______________________________________________
Opensim-users mailing list
Opensim-users at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-users

Checked by AVG - www.avg.com
Version: 8.5.375 / Virus Database: 270.12.94/2208 - Release Date:
07/05/09 17:54:00
_______________________________________________
Opensim-users mailing list
Opensim-users at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-users




More information about the Opensim-users mailing list