[farcry-dev] Re: Database Question

[Scott Stroz]

The alphanumeric string you are referring to is a 'Unique ID'.  One of the advantages of using this type of ID as opposed to an integer with auto increment is that the 'Unique ID' will NEVER be duplicated accross any table or database.  This makes it easier to import data into a table as you will not have to concern yourself with conflicts in the primary key.

I am sure there are other reasons why they are used, but this is the main reason why I use them.

On 5/17/05, Robert <[EMAIL PROTECTED]> wrote:

This is something I have been thinking about, and was just curious about.

I noticed that the objectid always is a alphanumeric string, how come the objectid is not just a number like 220 or 189.

Looking at the database it seems all objects are referenced from the refobjects table, so it seems possible to do, I am just not sure why it's not (perhaps a design issue I have been missing).

Personally I have always used plain numeric values for all primary keys in my tables, as a computer can compare and processes a number faster than it can a string of characters.

Just trying to understand FarCry more.

Thanks,

---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/

--
Scott Stroz
Boyzoid.com
___________________________
Some days you are the dog,
Some days you are the tree. --- You are currently subscribed to farcry-dev as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/