well gee i wouldnt use a text (datatype) column for one either but that wasnt the point of my question.
the point was, in making some sort of datatype like that, where it follows a format as far as its makeup and probably is derived through some sort of algorithm, you would think that there would be some built in functionality that made it a bit faster than a varchar with the same string of data in it. tw -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 5:18 PM To: CF-Talk Subject: RE: UUID's ( maybe OT) > but as a datatype in SQL Server 2000 > wouldn't you imagine that m$ has made > it so that the sql server engines running it > are tuned to perform well with these? Well, ntext is a datatype in SQL Server, but I don't think you'd want to use it for your primary key fields. You might not have much overhead using UUID fields for joins compared to integers, but I'm sure there's some. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ::::::::::::: dream :: design :: develop ::::::::::::: MXDC 02 :: Join us at this all day conference for designers & developers to learn tips, tricks, best practices and more for the entire Macromedia MX suite. September 28, 2002 :: http://www.mxdc02.com/ (Register today, seats are limited!) :::::::::::::::::::::::::::::::::::::::::::::::::::::: ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists