[Opensim-users] opensim migration strategy

[Frisby, Adam]

Well, go take a look

The code calling both is or should be close to identical - and the speed difference is there and very noticeable, so if there's any tricks you know of to make SQLite run faster, by all means feel free to make a patch - there's a lot of people who'd appreciate it.

Adam

From: opensim-users-bounces at lists.berlios.de [mailto:opensim-users-bounces at lists.berlios.de] On Behalf Of Generic Email
Sent: Friday, 5 December 2008 10:58 AM
To: opensim-users at lists.berlios.de
Subject: Re: [Opensim-users] opensim migration strategy

I am so glad you brought these up.
I believe these are also misconceptions...

In many circumstances, primarily where transactions are involved, SQLite beats the pants off mySQL http://www.sqlite.org/speed.html

Granted they are old tests, and I am sure we have all gotten better since then, but remember, it almost isn't a fair comparison. SQLite has hundreds of fewer features and an order of magnitude less complexity when compared with MySQL. All it does is quickly store and retrieve data.

Did you know that SQLite db writes are journaled, and and failure will result in the transactions being rolled back to a known good state? It is being used on literally millions of cellphones every day, with zero maintenance. If it was easy to corrupt, then I believe the major hardware manufacturers would be steering clear of it, but instead they are moving forward and paying for its maintenance.

I really enjoyed listening to http://twit.tv/floss26

Thanks again.

On Dec 5, 2008, at 1:36 PM, Frisby, Adam wrote:


The problem with SQLite is that it's very very slow by comparison.

There's a real noticeable difference between the speed it takes to perform operations, and that of say MySQL.

It's also a little bit easier to corrupt - for instance you can't have two processes accessing the one sqlite DB at once.

Adam

From: opensim-users-bounces at lists.berlios.de<mailto:opensim-users-bounces at lists.berlios.de> [mailto:opensim-users-bounces at lists.berlios.de] On Behalf Of Generic Email
Sent: Friday, 5 December 2008 8:10 AM
To: opensim-users at lists.berlios.de<mailto:opensim-users at lists.berlios.de>
Subject: Re: [Opensim-users] opensim migration strategy

This is a bit of a soap box, so if your are easily offended or annoyed, just pass by, there is nothing to see here.

I see in the OpenSim world the assertion that SQLite is not production worthy often. Most recently here:

http://opensimulator.org/wiki/Upgrading
SQLite (default - a lightweight database that comes bundled with OpenSim and can be used without requiring any extra configuration. It is mostly intended to get you up and running quickly, not for production use.)

I prefer to describe SQLite as:
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

These companies believe SQLite is production worthy/ready: http://www.sqlite.org/famous.html

I am a huge fan of SQLite, and for what it does, I believe it does it very well.

Thanks for letting me get that out, and I hope I can influence more of you to take a better look at SQLite.

On Dec 5, 2008, at 10:58 AM, Justin Clark-Casey wrote:



Paul Fishwick wrote: