<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>It seems the MySQL connector for .net assumes the db field is a string for its internal MySqlDataReader.GetGuid() implementation.<BR>
<BR>
(I could have been looking at source for an old revision of the connector, but that needs to be checked out anyway)<BR>
<BR>
So, that might mean that going binary could wreck stuff like nhibernate, if that's using a DataReader.<BR>
<BR>
Best,<BR>
/Stefan<BR><BR><BR><BR><BR>
<HR id=stopSpelling>
<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 we'll be<BR>> > changing things up at this level. Can we shoot for UUIDs being stored as<BR>> > a byte[16] in order to gain the 10x speedup in SQL 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 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></body>
</html>