Re: USA City, State lookup by zip code for Customer in Help Desk

[Axton]

** I have tables much larger than this (10m rows/800mb).  Just make sure you don't add any clobs to the table (prevents parallel execution on Oracle), keep the column sizes at the limits of the data (small record size helps appropriate use of indexes during query execution), index appropriately, and you will be fine.

Axton Grams

On 11/9/06, Grooms, Frederick W <[EMAIL PROTECTED]> wrote:

We have it here ... No Problems

We created an Regular Remedy form and loaded the data into it.

Just make sure you set up indexes for searching

Fred

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kelly Logan
Sent: Thursday, November 09, 2006 2:56 PM
To: arslist@ARSLIST.ORG
Subject: USA City, State lookup by zip code for Customer in Help Desk

Hello All,

I've had a request to have the entirety of possible US (including Puerto
Rico) zip codes available for City, State lookup in the Customer form
for Help Desk.

USPS has a ASCII file with all of them in readable format, but it looks
monstrous (an entire CD, zipped; better than a DVD, I guess).

We do not have an available outfacing web server, so a web service
lookup is not viable.

Has anyone tried this?  If so, what size and type of system are you on
and did the amount of data cause any issues?

Right now, if they decide they want to go forward with this, is to put
the data into a separate table and/or database and customize the Remedy
code to pull from it.  Again, any experience and/or advice on this is
welcome.

Thanks in advance!

Kelly Logan
Cybernetic Solutions, Inc.
[EMAIL PROTECTED]

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

__20060125_______________________This posting was submitted with HTML in it___