Subject | Re: [Firebird-Architect] Digest Number 959 |
---|---|
Author | Alexandre Benson Smith |
Post date | 2005-03-23T19:36:50Z |
Kevin Berry wrote:
For sure any byte saved on a key will be good, but if you use reversed
GUID the compression on the index will take care to keep it small. So,
maybe it won't be so bad to have a 32 char PK :-)
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005
>Sounds like a similar approach to the one I wouldKevin,
>take, except that I'd be using Delphi instead. :-)
>However, I worry about the performance and the
>additional space used by the longer fields. 16 bytes
>vs 36 bytes (or 32 bytes at the smallest) is quite a
>difference for key fields that must be indexed.
>
>
>
For sure any byte saved on a key will be good, but if you use reversed
GUID the compression on the index will take care to keep it small. So,
maybe it won't be so bad to have a 32 char PK :-)
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005