Optimal Performance String Searching with Hashes Re: VChar vs VText

[Ruslan Zasukhin]

On 11/30/05 5:08 PM, "Ed Kleban" <Ed at Kleban.com> wrote:

> But my whole point is that when you want to find a string fast, you use a
> hash, not comparisons embedded in some string package -- no matter who wrote
> it or how well.  In fact even the REALbaic "=" operator is one of the worst
> possible things to use to do string comparisons.  This is simply the wrong
> approach from my perspective.

I think it is good idea add Hash Index for STRING/VarChar fields which are
marked as Primary Key.

Just IMHO this is bad design make keys on strings. :-)

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]