Re: What's the most efficient primary key ?

From: --CELKO-- <joe.celko_at_trilogy.com>
Date: 22 Jul 2001 10:16:08 -0700
Message-ID: <7e67a7b3.0107220916.5172b282@posting.google.com>

>> I want to create billions of unique key, wat's the best option?...
options, it is good for using OID's <<

The real answer is that you should never try to force an OO model into an SQL database. I am spending the next 2-3 weeks of my life cleaning up such a database where someone used the SQL Server 2000 UNIQUEIDENTIFIER for the primary keys in all the tables and tried to build class hierarchies with mutlple tables that have meaningless column names. The database is both corrupt and slow. But it is making me rich.

Learn how to do a correct relatioal model. Get a copy of Visio and learn ORM. Received on Sun Jul 22 2001 - 12:16:08 CDT