I'm a businessman and run a leads generating company. I've purchased a large database and with help of hired outside programmers have created tables and written php scripts and have created a website that searches for leads, finds them and sells them to clients on-line.
My problem is searches under zip code or city do get results, however if searched by State or County, it generates too may results and get an error message:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 44 bytes) in /home/content/53/9340553/html/TLeads/system/database/drivers/mysql/mysql_result.php on line 152
Am I doing something that I was not supposed to do? Is SQL capable of handling such huge databases? Or, is this an scripting error?
Thanks in advance