<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:12pt"><div>What? You mean I was half-way on the ball this morning?<br><br>Charles<br></div><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Justin Clark-Casey <jjustincc@googlemail.com><br><b><span style="font-weight: bold;">To:</span></b> opensim-dev@lists.berlios.de<br><b><span style="font-weight: bold;">Sent:</span></b> Wednesday, January 7, 2009 8:08:16 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [Opensim-dev] Regionstore and all changes happening there.<br></font><br>
Ruud Lathrop wrote:<br>> The issue now has a patch, which is in the same style as the MySQL code. <br>> Strawberry tested it and if applied the alpha release is also ready for <br>> MSSQL.<br><br>Thanks Ruud. Looks like Charles already applied it this morning.<br><br>> <br>> Ruud<br>> <br>> On Mon, Jan 5, 2009 at 9:46 PM, Justin Clark-Casey <br>> <<a ymailto="mailto:jjustincc@googlemail.com" href="mailto:jjustincc@googlemail.com">jjustincc@googlemail.com</a> <mailto:<a ymailto="mailto:jjustincc@googlemail.com" href="mailto:jjustincc@googlemail.com">jjustincc@googlemail.com</a>>> wrote:<br>> <br>> Laurent wrote:<br>> > Hello,<br>> ><br>> >> Hi,<br>> >><br>> >> in what way is the MySQL rewrite hurting MSSQL?<br>> >><br>>
>> The two drivers are independent. MySQL now uses low level native<br>> >> calls, making it much faster.<br>> >><br>> >> Melanie<br>> ><br>> > Fixes has been done on both <a target="_blank" href="http://MySQLRegionData.cs">MySQLRegionData.cs</a> and<br>> <a target="_blank" href="http://SQLiteRegionData.cs">SQLiteRegionData.cs</a> at<br>> > release 7586. That fix was not applied to <a target="_blank" href="http://MSSQLRegionData.cs">MSSQLRegionData.cs</a>.<br>> ><br>> > SVN Log at 7586 :<br>> ><br>> > * Resolve <a href="http://opensimulator.org/mantis/view.php?id=2743" target="_blank">http://opensimulator.org/mantis/view.php?id=2743</a>
and<br>> > <a href="http://opensimulator.org/mantis/view.php?id=2739" target="_blank">http://opensimulator.org/mantis/view.php?id=2739</a> by no longer<br>> bothering to<br>> > store or retrieve the local parentID in<br>> > the region database<br>> > * The original issue is that the now randomly generated local ids<br>> do not fit<br>> > into the int parentID datatype<br>> > * However, as far as I know it's actually pointless to store this<br>> local<br>> > parent ID anyway (we already store the groupUUID), especially as<br>> we don't<br>> > bother to store the localID (as<br>> > opposed to UUID itself).<br>> > * Conservatively,
the actual column will be removed in a later commit<br>> ><br>> > I am sorry I dont have that much time to help more about it :(<br>> <br>> Okay, I made what I think are the matching changes to MSSQL in<br>> r7958, as detailed in<br>> <a href="http://opensimulator.org/mantis/view.php?id=2939" target="_blank">http://opensimulator.org/mantis/view.php?id=2939</a>. I tend to be a<br>> little hesitant about changing MSSQL since I can't<br>> test it, though it would probably have been easier just to go ahead<br>> with the blind fix in this case.<br>> <br>> ><br>> > Laurent<br>> > --------------------------------------------------<br>> > From: "Melanie" <<a ymailto="mailto:melanie@t-data.com"
href="mailto:melanie@t-data.com">melanie@t-data.com</a> <mailto:<a ymailto="mailto:melanie@t-data.com" href="mailto:melanie@t-data.com">melanie@t-data.com</a>>><br>> > Sent: Saturday, January 03, 2009 2:26 PM<br>> > To: <<a ymailto="mailto:opensim-dev@lists.berlios.de" href="mailto:opensim-dev@lists.berlios.de">opensim-dev@lists.berlios.de</a><br>> <mailto:<a ymailto="mailto:opensim-dev@lists.berlios.de" href="mailto:opensim-dev@lists.berlios.de">opensim-dev@lists.berlios.de</a>>><br>> > Subject: Re: [Opensim-dev] Regionstore and all changes happening<br>> there.<br>> ><br>> >> Hi,<br>> >><br>> >> in what way is the MySQL rewrite hurting MSSQL?<br>> >><br>>
>> The two drivers are independent. MySQL now uses low level native<br>> >> calls, making it much faster.<br>> >><br>> >> Melanie<br>> >><br>> >><br>> >> Ruud Lathrop wrote:<br>> >>> In relation to Mantis issue 2939, I see that there has been<br>> done a lot of<br>> >>> work on the RegionStore within the MySQL section. Sadly this is<br>> now also<br>> >>> hurting the MSSQL section. Can we please have some report on<br>> what is done<br>> >>> there, so we can update the MSSQL section?<br>> >>><br>> >>> Ruud<br>>
>>><br>> >>> PS and yes I have looked in the repository, but a lot is done<br>> and to go<br>> >>> throw all message is not a option as they are sometimes very short.<br>> >>><br>> >>><br>> >>><br>> >>><br>> ------------------------------------------------------------------------<br>> >>><br>> >>> _______________________________________________<br>> >>> Opensim-dev mailing list<br>> >>> <a ymailto="mailto:Opensim-dev@lists.berlios.de" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a> <mailto:<a ymailto="mailto:Opensim-dev@lists.berlios.de"
href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a>><br>> >>> <a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>> >> _______________________________________________<br>> >> Opensim-dev mailing list<br>> >> <a ymailto="mailto:Opensim-dev@lists.berlios.de" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a> <mailto:<a ymailto="mailto:Opensim-dev@lists.berlios.de" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a>><br>> >> <a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>> >><br>> >
_______________________________________________<br>> > Opensim-dev mailing list<br>> > <a ymailto="mailto:Opensim-dev@lists.berlios.de" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a> <mailto:<a ymailto="mailto:Opensim-dev@lists.berlios.de" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a>><br>> > <a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>> ><br>> <br>> <br>> --<br>> justincc<br>> Justin Clark-Casey<br>> <a href="http://justincc.wordpress.com" target="_blank">http://justincc.wordpress.com</a><br>> _______________________________________________<br>> Opensim-dev mailing list<br>>
<a ymailto="mailto:Opensim-dev@lists.berlios.de" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a> <mailto:<a ymailto="mailto:Opensim-dev@lists.berlios.de" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a>><br>> <a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>> <br>> <br>> <br>> ------------------------------------------------------------------------<br>> <br>> _______________________________________________<br>> Opensim-dev mailing list<br>> <a ymailto="mailto:Opensim-dev@lists.berlios.de" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a><br>> <a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br><br><br>-- <br>justincc<br>Justin
Clark-Casey<br><a href="http://justincc.wordpress.com" target="_blank">http://justincc.wordpress.com</a><br>_______________________________________________<br>Opensim-dev mailing list<br><a ymailto="mailto:Opensim-dev@lists.berlios.de" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a><br><a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br></div></div></div></body></html>