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

[Justin Clark-Casey]

Laurent wrote:
> 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 :(

Okay, I made what I think are the matching changes to MSSQL in r7958, as detailed in 
http://opensimulator.org/mantis/view.php?id=2939.  I tend to be a little hesitant about changing MSSQL since I can't 
test it, though it would probably have been easier just to go ahead with the blind fix in this case.

> 
> 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
>>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
> 


-- 
justincc
Justin Clark-Casey
http://justincc.wordpress.com