Zip code program problem

[nyxx23]

I'm having a problem with a zip code lookup program and was wondering if someone could help me.

I read in the zip codes from a census bureau file and store the zip and states in arrays. I then read in the individual's zip code from an oracle database. And then I search the approximately 32,000 zip codes for this one.

The program ends up timing out because the zip code lookup takes too long. Is there some efficient way I can look up each zip code? I keep trying different things, but they all end up timing out.

Thanks.

[tomhath]

Put the 30,000 codes from the file into a database table with a unique index on that column and join to that table from your other table.