[Opensim-dev] Regionstore and all changes happening there.

[Laurent]

Hello,

> Hi,
>
> in what way is the MySQL rewrite hurting MSSQL?
>
> The two drivers are independent. MySQL now uses low level native
> calls, making it much faster.
>
> Melanie

Fixes has been done on both MySQLRegionData.cs and SQLiteRegionData.cs at 
release 7586. That fix was not applied to MSSQLRegionData.cs.

SVN Log at 7586 :

* Resolve http://opensimulator.org/mantis/view.php?id=2743 and 
http://opensimulator.org/mantis/view.php?id=2739 by no longer bothering to 
store or retrieve the local parentID in
the region database
* The original issue is that the now randomly generated local ids do not fit 
into the int parentID datatype
* However, as far as I know it's actually pointless to store this local 
parent ID anyway (we already store the groupUUID), especially as we don't 
bother to store the localID (as
opposed to UUID itself).
* Conservatively, the actual column will be removed in a later commit

I am sorry I dont have that much time to help more about it :(

Laurent
--------------------------------------------------
From: "Melanie" <melanie at t-data.com>
Sent: Saturday, January 03, 2009 2:26 PM
To: <opensim-dev at lists.berlios.de>
Subject: Re: [Opensim-dev] Regionstore and all changes happening there.

> Hi,
>
> in what way is the MySQL rewrite hurting MSSQL?
>
> The two drivers are independent. MySQL now uses low level native
> calls, making it much faster.
>
> Melanie
>
>
> Ruud Lathrop wrote:
>> In relation to Mantis issue 2939, I see that there has been done a lot of
>> work on the RegionStore within the MySQL section. Sadly this is now also
>> hurting the MSSQL section. Can we please have some report on what is done
>> there, so we can update the MSSQL section?
>>
>> Ruud
>>
>> PS and yes I have looked in the repository, but a lot is done and to go
>> throw all message is not a option as they are sometimes very short.
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Opensim-dev mailing list
>> Opensim-dev at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-dev
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>