Re: When to use integer keys?

From: Cimode <cimode_at_hotmail.com>
Date: 24 Jan 2007 01:04:43 -0800
Message-ID: <1169629483.775059.104350_at_j27g2000cwj.googlegroups.com>


Logical perspective:
See above comments...

Performance perspective:
>From what I observed what should guide the typing int/text of a
specific (or more generally numeric/text) is performance of platform dependent implementations (in direct image systems, operations such as JOIN by numeric cumulatively consume less IO/RAM resources than nonnumeric) and sorting characteristics by the platform you are using(ASCII vs other --> different sort orders) and the one you intent to build (according to what attribute are you likely to sort out frequently).

Hope this helps... Received on Wed Jan 24 2007 - 10:04:43 CET

Original text of this message