complicated database selection

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
speedy33417
Forum Contributor
Posts: 128
Joined: Sun Jul 23, 2006 1:14 pm

complicated database selection

Post by speedy33417 »

I'm working on a mailing list database that contains tens of thousands of local addresses. The database is built so it includes several additional data for each address.
Clients will make selection from the database based on hundreds of criteria.

How is it possible to work with huge amount of random selection?

Any ideas? Please tell me what you think.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Sometimes one will use a separate table to temporarily store the result set information. Not necessarily all the columns, but enough to fetch the information quickly.
Post Reply