Re: Working with U.S. Zip Codes
Date: 1996/04/24
Message-ID: <317F0C27.39CA_at_sgi-hi.com>#1/1
Jessica wrote:
>
> I am currently working on an application (to be run under an ORACLE7
> database) which requires me to find the state for a specific U.S. zip
> code....clip... The list has over 33,000 entries of zip
> codes, cities, and states. But rather than having to search the entire
> table each time, I'm wondering if anyone is aware of a more optimal
> solution for such task.
>
If performance is the issue, I don't think you need to worry...why not go for the entire table.
Basis for opinion: I ran a demo a couple of years ago on the entire zip code table. I ended up with > 180,000 occurrences (but the table I had also included zip correlation to counties). Response time on queries < 1 sec. on zip or city name at the client.
The table was loaded on MS SQL Server, but I don't think Oracle would give you any worse performance.
Why not go for the gusto...all? Received on Wed Apr 24 1996 - 00:00:00 CEST