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

[Ruud Lathrop]

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.

Ruud

On Mon, Jan 5, 2009 at 9:46 PM, Justin Clark-Casey <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>
> > 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
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20090107/10cea733/attachment-0001.html>