[Opensim-dev] nhibernate progress, baby steps

[Stefan Andersson]

Yeah, well; I'm not saying it IS, just that we need to check on it.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.
 
/Stefan



> Subject: RE: [Opensim-dev] nhibernate progress, baby steps> From: brianw at terrabox.com> To: stefan at tribalmedia.se> CC: opensim-dev at lists.berlios.de> Date: Thu, 3 Apr 2008 13:04:37 -0500> > > Ouch. That's not good. > > > On Thu, 2008-04-03 at 19:55 +0200, Stefan Andersson wrote:> > It seems the MySQL connector for .net assumes the db field is a> > string for its internal MySqlDataReader.GetGuid() implementation.> > > > (I could have been looking at source for an old revision of the> > connector, but that needs to be checked out anyway)> > > > So, that might mean that going binary could wreck stuff like> > nhibernate, if that's using a DataReader.> > > > Best,> > /Stefan> > > > > > > > > > > > ______________________________________________________________________> > > > > Date: Thu, 3 Apr 2008 13:49:03 -0400> > > From: sean at dague.net> > > To: brianw at terrabox.com; opensim-dev at lists.berlios.de> > > Subject: Re: [Opensim-dev] nhibernate progress, baby steps> > > > > > On Thu, Apr 03, 2008 at 11:19:58AM -0500, Brian Wolfe wrote:> > > > *nod* sounds good to me as well. I just have one request since> > we'll be> > > > changing things up at this level. Can we shoot for UUIDs being> > stored as> > > > a byte[16] in order to gain the 10x speedup in SQL> > indexing/storage vs> > > > string(32|36) ?> > > > > > That's definitely an option. It did however seem like there was some> > > speedup on LLUUID processing if we kept strings. I'm not sure where> > the> > > two end up colliding on speedup effects.> > > > > > -Sean> > > > > > -- > > > __________________________________________________________________> > > > > > Sean Dague Mid-Hudson Valley> > > sean at dague dot net Linux Users Group> > > http://dague.net http://mhvlug.org> > > > > > There is no silver bullet. Plus, werewolves make better neighbors> > > than zombies, and they tend to keep the vampire population down.> > > __________________________________________________________________> > > 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080403/806bbc0c/attachment-0001.html>