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 use SQL Server's newid() which *should* almost always be faster. On Mon, Dec 20, 2010 at 11: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 enterprise application with millions of rows in the table? > > Thanks for all your feedback, > > Brian > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm