[Opensim-dev] switch gears a bit, thoughts on the state of the database in OpenSim

[Melanie]

I believe that the individual drivers approach should not be dropped.
Any abstraction/generalization would of necessity forgo performance 
enhancing database features and would therefore be detrimental to 
the scaling behavior down the road.

For databases off the beaten track, we could possibly provide a 
generic or abstracted driver, but, IMHO, a very specific, high 
performance MySQL driver needs to stay as part of OpenSim.

That said, the current one isn't really all that high performance, 
but that is where it needs improving.

Melanie


Sean Dague wrote:
> Stefan Andersson wrote:
>> Sean,
>>  
>> may I then revoke my earlier suggestion to drop the OpenSim.Data.Base, and instead suggest we concentrate on that, since that WAS a stab at getting reasonably cheap and customizable cross-db functionality? Converting current db providers to the Base framework really should be a breeze.
>> It does give us things like seamless LLUUID, vector and rotation handling, as well as the possibility to write specialized queries. It also isolates connection factoring so that that we can have much more detailed control over it for various environments.
>>  
>> If the migration framework could be added to that, I think we would have something really simple, compact and efficient that will last us until we get something better on rails?
> 
> I'll look into it.  Honestly, right now I'd rather start with cleaning
> what we've got before trying to consolidate it again.  I think part of
> why this continues to be elusive is that there are so many
> inconsistencies even within existing drivers that it is hard to see the
> forest for the trees.  Having been doing some parallel work on 3 db
> drivers of late (sqlite, mysql, and nhibernate) I'm starting to see some
>  patterns that make sense, but I'd rather just make some incremental
> improvements at this point and see where those go, instead of promissing
> a new approach to unification here.
> 
> 	-Sean
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev