Searching thru 400,000 records

[mays0515]

Hi Everyone,

I need help with my application speed. I have a form that first asks for last name, then goes thru 400,000 records to search all first names in the database with that last name. Then, i search again thru the 400,000 records to get all the states with that first and last name combination and then i search again to get all the cities with that first name, last name and state combination. This takes a LONG time! And is not very efficient, especially when doing multiple searches. Can anyone suggest how I can make it faster/more efficient?

Thanks in advance!!
-Mays

 

[Mile-O]

Why not do it all at once?

 

[mays0515]

I didnt do it all at once b/c alot of times, when someone is doing the search, they only know the last name and state fields----if i narrow it down by last name, it is easier for the user----they wouldnt have to do the search as many times when i narrow down the fields for them.