Re: Ultra fast db access & searching?

"Aerodyne" <aerodynex@xxxxxxxxx> writes:

> Thanks IchBin .... but I'm sure even with HSQLDB searching through
> millions of unique user names can be optimize in some way or another.
> What are the best solutions for this task or do most just leave the
> database do it with out a good design.
>
> Hotmail has 150+ million users ... yet they get back to you very
> quickly as if the user name is already in use & several suggestions!
>
> I'm just looking for good database design if any or tricks for fast
> searching... ie instead of putting the complete city name in a field
> (LosAngeles) you just use LA, that way you only have to search for two
> characters rather than all 10 for equality or like wise for all other
> cities ... just a 3 letter acronym.

You are on to something here. I believe it is called hashing :)

--
dt

However, experience shows that for many people and many applications a
dose of paranoia is reasonable - Bjarne Stroustrup
.

Relevant Pages

  • Re: Searching all fields in a record
    ... a database design that puts values in any field requires searching ... > to time and I don't want to rewrite this query every time. ...
    (microsoft.public.access.queries)
  • Re: Ultra fast db access & searching?
    ... but I'm sure even with HSQLDB searching through ... millions of unique user names can be optimize in some way or another. ... I'm just looking for good database design if any or tricks for fast ...
    (comp.lang.java.databases)
  • Re: Weird query ??
    ... Try searching the Internet on things like database normalization ... Go to the library and check out a book on database design ...
    (comp.lang.php)