Page 1 of 1

complicated database selection

Posted: Fri Jan 26, 2007 7:26 am
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.

Posted: Fri Jan 26, 2007 7:54 am
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.