So, anyone have any thoughts on which are better... Using CF8 Ent, SQL 2k5
Ent and an enterprise application with millions of rows in the table?
Thanks for all your feedback,
Brian
~|
Order the Adobe Coldfusion Anthology
Auto Incrementing Seed - bigint (max 9,223,372,036,854,775,807 rows) or int
(max 2,147,483,647 rows)
CF UUID (max functionally infinite rows)
...so choose the smallest one of those that is large enough to be
future-proof for your table.
NOTE: when I use UUID, I don't use CF UUID. Instead, I
If you are using it as an ID, I go with UUID. Makes it a little harder
to put into the URL to look up things they shouldn't.
On Mon, Dec 20, 2010 at 9:34 AM, Brian Polackoff bpolack...@gmx.com wrote:
So, anyone have any thoughts on which are better... Using CF8 Ent, SQL 2k5
Ent and an
...@mostdeadlygame.com
Sent: Monday, December 20, 2010 12:58 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: Auto Incrementing Seed vs CF UUID
If you are using it as an ID, I go with UUID. Makes it a little harder
to put into the URL to look up things they shouldn't.
On Mon, Dec 20, 2010 at 9
So, anyone have any thoughts on which are better... Using CF8 Ent, SQL 2k5
Ent and an enterprise application with millions of rows in the table?
Do you plan to use these records anywhere other than this database
server (replication, migration)? If so, use a UUID. But you might want
to let the
If you are using it as an ID, I go with UUID. Makes it a little harder
to put into the URL to look up things they shouldn't.
If your applications allow people to substitute values and see things
they shouldn't see, you have bigger problems than integers vs UUIDs.
Dave Watts, CTO, Fig Leaf
Of course I check the values and such when I need to. But for
something like a I forgot my password system, I'd rather give them a
key of a UUID then an integer.
On Mon, Dec 20, 2010 at 10:44 AM, Dave Watts dwa...@figleaf.com wrote:
If you are using it as an ID, I go with UUID. Makes it a
Generally, unless you have a specific need to use UUIDs/GUIDs, such as in
replication scenarios, integers are the better choice. Kimberly Tripp has a
great presentation on this subject if you ever get a chance to take one of
her classes. She spends an hour detailing all the ways the use of GUIDs
8 matches
Mail list logo