[Opensim-dev] Estates Estates everywhere and nowhere to save

[Sean Dague]

On Wed, Dec 19, 2007 at 10:18:28PM +0800, Adam Frisby wrote:
> That wont really work - we dont reload from the DB or do things "live" 
> there. IE you cant change the primitives table while the sim is still 
> running and everything updates.

That is because our patern for prim storage is old, and based on the
db4o pattern.  A lot of our database usage patterns need help to be a
lot cleaner and more efficient.  The current get and load everything
into memory approach is going to start tapping out as the content in the
environments gets larger.

Top of my list for the new year is to give the database layer some
loving again.  The patterns that Tleiades created for the MySQL asset
server are a good start in the right direction.

> The INI is handy because you can use a text editor, it's clean - and
> easy to manipulate from other GUI tools should someone choose to write
> one.  Having to connect to the database to do edits for some very
> strictly defined single-value fields seems a little .. shall we say,
> overengineered.

I disagree pretty strongly on that point.  Ming's checkin from yesterday
brings a lot of this into the database already, and it works nicely.
The moment you are trying to manage more than a handful of regions,
having to go track down flat files to do so is quite a pain.

       -Sean

-- 
__________________________________________________________________

Sean Dague                                       Mid-Hudson Valley
sean at dague dot net                            Linux Users Group
http://dague.net                                 http://mhvlug.org

There is no silver bullet.  Plus, werewolves make better neighbors
than zombies, and they tend to keep the vampire population down.
__________________________________________________________________
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20071219/80cdfff9/attachment-0001.pgp>