View Full Version : database: zipData
February 8th, 2012, 05:20 PM
When look at my reviewpost database, I see a table called zip data that has 8MB already even though we just started.
Could you please tell me what is zipdata, and why is it so big?
February 8th, 2012, 05:25 PM
That is the US zipcode database which should be 8mb and holds the zipcode data so that you can use the distance calculations.
February 8th, 2012, 05:47 PM
Thanks Chuck. Where do we need to calculate the distance?
What is a safeway to remove this? Backing up the database is an important task, I'd like to remove this large overhead table if possible.
Thank you very much!
February 8th, 2012, 06:08 PM
Just make sure in your admin panel the setting to use zipcode integration is set to NO. You can then truncate that database table.
February 8th, 2012, 06:49 PM
Thank you Chuck.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.