Subject | RE: [Firebird-Architect] Indexes for big objects |
---|---|
Author | Leyne, Sean |
Post date | 2006-07-10T18:50:56Z |
Ann,
problem -- for our users -- at the moment we need to focus on more
important items.
I am reluctant to consider creating a new type of index which has a
single purpose (uniqueness), that can't be used for other purposes.
Sean
> Leyne, Sean wrote:I understand, but I see that problem as being a .0000001% percent
> >
> > I don't see the value of this type of index, expect to handle
> > uniqueness.
> >
> Yes - if you were setting up a list with messages, identifying
> messages that are exactly identical lets you detect one kind
> of spam.
problem -- for our users -- at the moment we need to focus on more
important items.
> For another, the hash index is very dense comparedDisk space is very cheap!!!
> to a multi-thousand byte string. There are algorithms for
> compressing the trailing characters, but we don't use them, so
> a 4,000 byte key that differs in the 3,000th byte will create
> an entry thats 1,000 bytes long.
I am reluctant to consider creating a new type of index which has a
single purpose (uniqueness), that can't be used for other purposes.
Sean