I just started reading Ben Forta's book "Reality ColdFusion MX" and in the first project he says using UUID's for a primary key is the way to go, especially if you are going to cluster. Is there any reason why you would not want to cluster using a maxid type of function? I know a UUID is never duplicated which may be part of the answer, but I'm just curious. I can see where a UUID may offer greater security, but if queries are properly protected with adequate rules, and use of val(), cfqueryparam, etc... then maxid should be fine.
Now the real reason I wrote this is it would seem just as important if not more so getting your site indexed by the search engines, and having easy to read and enter URL & query strings which I think is better for users and search engines. I know there is a fair bit of debate between SES URL's versus traditional URL query strings that uses question marks "?", equal signs "=", and ampersands "&". For example, the following URL I know will be indexed by the search engines, and it also makes use of keywords (which is really good for SEO), and is not hard to type if required, though it is kind of long, but not near as long as using UUID's. So it would seem from a search engine and marketing point of view an approach like the following might be better: http://www.aftershockweb.com/categories/index.cfm/CategoryID/36/panasonic/ma ssagechairs (In this case I am able to highlight my keywords "Panasonic" and "Massage Chairs". This page has only been up for a week, so it will be interesting to see how it will come up in the future.) If UUID's or GUID's are used then a URL might look like the following (using a "SES") URL: http://www.somedomain.com/categories/index.cfm/CategoryID/14CDFFC5-72A1-8C91 -604BB6CA553B7328&ProductID/FB973CE8-F222-14D6-E133-145150736A2 Needless to say the above is not very pretty or easy to type, though it would get indexed and make Ben happy. However it does not make use of keywords, which is I think another big strike against it. Just curious to see what others have to say about SES/SEO URL's vs. UUID as the primary key. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228575 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
