Ultra fast db access & searching?
- From: "Aerodyne" <aerodynex@xxxxxxxxx>
- Date: 24 Nov 2005 07:22:59 -0800
Hi all,
Could some one help me out with this Q?
If I designed a db (MySQL or PostgreSQL) & it contained more than 5+
million users with all unique user names... how can I speed up db
access ...etc to search a new users name if it has already been taken?
All hints & tips welcome (plus good db books on this matter & some)...
The reason I ask is to know how sites like hotmail, gmail, ebay ...etc
all do it so quickly! But I'd prefer to use either MySQL or
PostgreSQL.
TIA
.
- Follow-Ups:
- Re: Ultra fast db access & searching?
- From: Bill Karwin
- Re: Ultra fast db access & searching?
- From: IchBin
- Re: Ultra fast db access & searching?
- Prev by Date: Re: Needed: An Efficient, reliable and smart way to copy data from one DB to another
- Next by Date: Re: connection ms Access to MIDlet
- Previous by thread: Unable to update record in java
- Next by thread: Re: Ultra fast db access & searching?
- Index(es):