[Opensim-dev] 20,256 prim test

[Sean Dague]

On Thu, Dec 13, 2007 at 09:50:06AM +0100, Stefan Andersson wrote:
> A note regarding the Sqlite/MySQL (and possibly MSSQL, if it's based on the same code) RegionStore implementation;
>  
> the region datastore in those adapters is borked, as it depends on a
> pre-initialized and re-used set of commands, all connected to one db
> connection, which means that we need to lock the database while
> updating (else the commands risk getting effed up), and that we never
> can use more than one connection. This means all db requests are
> thread-and-db synch end to end, which leads to real bad response
> times.That needs to be remedied asap. I have a tablemapper/rowmapper
> pattern on my hard disk that I could commit for discussion if the crew
> see fit?

Yes, the base pattern for storage needs help.  When that was written the
sim only tended to survive for short windows of time, and we had no
physics, so people weren't really building much.  

I'd love to see your tablemapper/rowmapper pattern.

    -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/20071213/242dca14/attachment-0001.pgp>