<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>Yeah, well; I'm not saying it IS, just that we need to check on it.<BR><BR>I glimpsed that as I was trying to find out what the 'best practice' for storing guids in MySQL databases was; I actually didn't find any good info on that.<BR>
<BR>
/Stefan<BR><BR><BR>
<HR id=stopSpelling>
<BR>
> Subject: RE: [Opensim-dev] nhibernate progress, baby steps<BR>> From: brianw@terrabox.com<BR>> To: stefan@tribalmedia.se<BR>> CC: opensim-dev@lists.berlios.de<BR>> Date: Thu, 3 Apr 2008 13:04:37 -0500<BR>> <BR>> <BR>> Ouch. That's not good. <BR>> <BR>> <BR>> On Thu, 2008-04-03 at 19:55 +0200, Stefan Andersson wrote:<BR>> > It seems the MySQL connector for .net assumes the db field is a<BR>> > string for its internal MySqlDataReader.GetGuid() implementation.<BR>> > <BR>> > (I could have been looking at source for an old revision of the<BR>> > connector, but that needs to be checked out anyway)<BR>> > <BR>> > So, that might mean that going binary could wreck stuff like<BR>> > nhibernate, if that's using a DataReader.<BR>> > <BR>> > Best,<BR>> > /Stefan<BR>> > <BR>> > <BR>> > <BR>> > <BR>> > <BR>> > ______________________________________________________________________<BR>> > <BR>> > > Date: Thu, 3 Apr 2008 13:49:03 -0400<BR>> > > From: sean@dague.net<BR>> > > To: brianw@terrabox.com; opensim-dev@lists.berlios.de<BR>> > > Subject: Re: [Opensim-dev] nhibernate progress, baby steps<BR>> > > <BR>> > > On Thu, Apr 03, 2008 at 11:19:58AM -0500, Brian Wolfe wrote:<BR>> > > > *nod* sounds good to me as well. I just have one request since<BR>> > we'll be<BR>> > > > changing things up at this level. Can we shoot for UUIDs being<BR>> > stored as<BR>> > > > a byte[16] in order to gain the 10x speedup in SQL<BR>> > indexing/storage vs<BR>> > > > string(32|36) ?<BR>> > > <BR>> > > That's definitely an option. It did however seem like there was some<BR>> > > speedup on LLUUID processing if we kept strings. I'm not sure where<BR>> > the<BR>> > > two end up colliding on speedup effects.<BR>> > > <BR>> > > -Sean<BR>> > > <BR>> > > -- <BR>> > > __________________________________________________________________<BR>> > > <BR>> > > Sean Dague Mid-Hudson Valley<BR>> > > sean at dague dot net Linux Users Group<BR>> > > http://dague.net http://mhvlug.org<BR>> > > <BR>> > > There is no silver bullet. Plus, werewolves make better neighbors<BR>> > > than zombies, and they tend to keep the vampire population down.<BR>> > > __________________________________________________________________<BR>> > <BR>> <BR><BR></body>
</html>