|
Cool, I downloaded the csv, and dumped it into a mysql database, there is a shitload of records. Even on my local webserver (no load whatsoever) queries take around 5 seconds, so I'm guessing using their binary version is faster. I tried indexing the tables and optimizing things, but it hasn't done much.
I plan on optimizing it, and maybe coming up with a US-only database to hit. I'll share my code in this thread, with a small class to extract data, it's pretty simple.
I know it won't be totally accurate, they disclose that on their site, the free version is much less accurate than paid, but if it's in the close vicinity, I don't see why we couldn't use it, if anything just to attact the user's attention, or maybe even to do some demographic study for your paysite members. I'll keep everyone posted in this thread with whatever I come up with.
|