Re: Ultra fast db access & searching?

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.

.

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)