I recommend against UUID for primary keys, integers are quicker and easier to handle, what I do however, I still add a UUID to every table but do not use it for relationships or to pull data, I use this more for global info, like which data was updated last within the db, what data was last published etc. I only use it for global info.
Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Yorke Hinds > Sent: Thursday, 12 February 2004 9:13 AM > To: CFAussie Mailing List > Subject: [cfaussie] Whats your Primary Key? > > > What is the support in the AU community for the > use of UUID over numeric primary keys in a DB/table? > > If not using UUID in as the primary key in the DB/table, > what can be used to encode or mask url variables that > include the primary key. I am aware of session variables > and form variables to hide numeric records. > > Anyone with experience - can you share. > > Thanks > > > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
