I added GeoDirectory to my BuddyPress powered food blog at https://FoodSocialSite.com and have about 1/2 million restaurants, bakeries, etc. with geo coordinates that I can import.
I started the first import of 44,000 bakeries and interrupted the import at about 1,400 listings because the site was really slow responding.
The import was also taking a long time, so I didn’t want the site to be unresponsive for months, so I interrupted the import.
My Question Is
Does Anyone Know How to Do One of the Following?
1. Make it “Drip” the place import at a rate of speed? ie: 1 per 30 seconds, 1 per minute, one per 3 minutes. If it has to be slow, let it be slow, but then slow it enough to not disrupt the front end.
2. Import an InfoUSA CSV directly into MySQL? That should be fast and if it makes the site slow, at least it could be done in the wee hours and expected to be complete before the day’s traffic.