No subject

Sat Apr 19 01:53:27 UTC 2014

There may be other benefits to MySQL but these alone are completely worth it for me.

- Len

On Mon, Jul 6, 2009 at 2:31 PM, Justin Clark-Casey <jjustincc at googlemail.com> 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.

--
justincc
Justin Clark-Casey
http://justincc.wordpress.com
_______________________________________________
Opensim-users mailing list
Opensim-users at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-users

_______________________________________________
Opensim-users mailing list
Opensim-users at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-users

--0-1022010365-1246909798=:85947
Content-Type: text/html; charset=us-ascii

<html><body bgcolor="#FFFFFF"><div>All of the aforementioned,</div><div>And</div><div>MySQL has professional tools available such as TOAD, and PRO level support thru Sun micro.<br><br>Sent from my iPhone</div><div><br>On Jul 6, 2009, at 2:35 PM, Len Brown <<a href="mailto:lenwbrown at gmail.com">lenwbrown at gmail.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>From personal experience here, I use MySQL mainly for persistence.  In other words, with SQLite when you shut down the server and start it up again you find such annoyances as your avatar defaults back to the plain jane "Ruth."  With MySQL I had added a custom shape, skin and clothing, hair and eyes and attachments and those remain in effect when the server is shut down and restarted.<br>
<br>There may be other benefits to MySQL but these alone are completely worth it for me.<br><br>- Len<br><br><div class="gmail_quote">On Mon, Jul 6, 2009 at 2:31 PM, Justin Clark-Casey <span dir="ltr"><<a href="mailto:jjustincc at googlemail.com"><a href="mailto:jjustincc at googlemail.com">jjustincc at googlemail.com</a></a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">Robert Klein wrote:<br>
> What are the absolute key advantages or disadvantages to using SQLite vs<br>
> MySQL for OpenSim?<br>
<br>
</div>afaik, SQLite is generally better for single user low-load applications, while MySQL is better for high load multi-user<br>
ones.<br>
<br>
In OpenSim this would translate to SQLite being fine for single user standalones (such as sandboxes), with MySQL being<br>
worth the setup hassle for anything beyond that.<br>
<font color="#888888"><br>
--<br>
justincc<br>
Justin Clark-Casey<br>
<a href="http://justincc.wordpress.com" target="_blank"><a href="http://justincc.wordpress.com">http://justincc.wordpress.com</a></a><br>
</font><div><div></div><div class="h5">_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users at lists.berlios.de"><a href="mailto:Opensim-users at lists.berlios.de">Opensim-users at lists.berlios.de</a></a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank"><a href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a></a><br>
</div></div></blockquote></div><br>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Opensim-users mailing list</span><br><span><a href="mailto:Opensim-users at lists.berlios.de">Opensim-users at lists.berlios.de</a></span><br><span><a href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a></span><br></div></blockquote><br>

      </body></html>
--0-1022010365-1246909798=:85947--