All,    
   
>From a performance standpoint what is the downside to using a UUID column?  
>Our current database with 25 locations after 5 years is only about 2.5 gig.  
>We do about 200,000 orders per year so we are not getting hit with a huge 
>amount  
of data.  Much of our data is static or once it has been processed it is static 
from that point forward.  The only reason that I was thinking about using a 
UUID data type is that this is a commerical product and we are also looking to 
move into  
the ASP space.  It is possible that we might have 2 companies merge and I 
thought that using the UUID would cause less hassles if we had to merge 2 
databases.  That being said the changes of that happening are pretty slim.  
I've got one  
DBA telling me that I should be using a UUID datatype for all of our tables.

Best Regards,

Michael Gould, Manager Information Technology
All Coast Intermodal Services, Inc.
First Coast Intermodal Services, Inc.
First Coast Logistics Services, LLC.
904-226-0978
904-592-5250 fax
      
   
 

Reply via email to