Subject | Re: [firebird-support] Re: Dynamic Variable Instantiation Within A Stored Procedure |
---|---|
Author | Alexandre Benson Smith |
Post date | 2005-11-09T00:20:55Z |
Adam wrote:
I was talking about the "Word x Record" table, it will have a lot of
duplicates since a lot of records will have the word "Alexandre" for
example.
The Word table will have no duplicates, and will be big, but the "Word x
Record" table will have a lot of duplicates and be *huge* ;-)
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
>>It will be huge, but I don't see a problem with it, you will need to:-)
>>look at indices statistics after the table is populated to see if you
>>have a lot of duplicates, if so, you could add the primary key to the
>>end of the table to help garbage collection process to run.
>>
>>
>>
>
>If he only adds unique words as has been described, there will be no
>duplicates
>
>;)
>
>
I was talking about the "Word x Record" table, it will have a lot of
duplicates since a lot of records will have the word "Alexandre" for
example.
The Word table will have no duplicates, and will be big, but the "Word x
Record" table will have a lot of duplicates and be *huge* ;-)
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br