Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

Dealing with Large Datasets

AccuZIP supports a maximum file size of 2GB. When dealing with large datasets, here are some steps to figure out how many records you can work with in AccuZIP6 for your given database.

First, you'll create a small sample file of your database. This doesn't harm the original file if your original file is an Excel or text file. 

Open your list in AccuZIP6 and use Edit menu > Delete to delete all but 500 records. Check the Pack Database box before clicking Delete.

Now that you have a small sample size, run address validation with NCOALink.

Now you can determine how many records will fit in the table by following the formula below:

  • From the Edit menu, choose Fields
  • Click on the Table tab.
  • You will see Records: Fields: and Length:
  • If you'll be presorting, write down the length and add 172 to the length (so if you see a length of 500, your length after presort will be 672)
  • Divide 2000 by the Length and you will get the number of records you can bring into this table. (For example, if the Length (after adding 172 for the presort field lengths) =680 then 2000 ÷ 680 = 2.94 million records. )

Now you know exactly how many records you can import based on address validation with NCOALink and based on address validation and presorting.

« Back to Tech Notes

I am especially motivated to take time to draw attention to Vince. In two instances, we potentially faced loss of product – significant loss, but thanks to everyone’s efforts, most notably Vince’s, we ended up with minor re-work and zero loss of stock. He’s patient and thorough, knowledgeable and resourceful. And he’s patient – A Big Plus when dealing with me. Long story short, the guy was able to not only produce a solution, but to prove to me the veracity of it. I hung up the phone saving thousands of dollars in catalog stock, not lost but salvaged, and my department had to spend just a wee bit of time on job re-work (which I was happy to do, all things considered). But I also hung up with a peculiar urge to write about Vince, incongruent as that may be since I rarely am moved to write letters of this sort. So… In a time of crisis, Vince was a terrific asset and ally. If I were his boss, I’d attempt a merit raise authorization, he was that exceptional.
H.D., Shawnee Mission, KS