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>
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