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

[Justin Clark-Casey]

Ruud Lathrop wrote:
> The issue now has a patch, which is in the same style as the MySQL code. 
> Strawberry tested it and if applied the alpha release is also ready for 
> MSSQL.

Thanks Ruud.  Looks like Charles already applied it this morning.

> 
> Ruud
> 
> On Mon, Jan 5, 2009 at 9:46 PM, Justin Clark-Casey 
> <jjustincc at googlemail.com <mailto:jjustincc at googlemail.com>> wrote:
> 
>     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 <mailto:melanie at t-data.com>>
>      > Sent: Saturday, January 03, 2009 2:26 PM
>      > To: <opensim-dev at lists.berlios.de
>     <mailto: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 <mailto:Opensim-dev at lists.berlios.de>
>      >>> https://lists.berlios.de/mailman/listinfo/opensim-dev
>      >> _______________________________________________
>      >> Opensim-dev mailing list
>      >> Opensim-dev at lists.berlios.de <mailto:Opensim-dev at lists.berlios.de>
>      >> https://lists.berlios.de/mailman/listinfo/opensim-dev
>      >>
>      > _______________________________________________
>      > Opensim-dev mailing list
>      > Opensim-dev at lists.berlios.de <mailto:Opensim-dev at lists.berlios.de>
>      > https://lists.berlios.de/mailman/listinfo/opensim-dev
>      >
> 
> 
>     --
>     justincc
>     Justin Clark-Casey
>     http://justincc.wordpress.com
>     _______________________________________________
>     Opensim-dev mailing list
>     Opensim-dev at lists.berlios.de <mailto: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