I have purchased the esyndicat directory script (Removed by [url removed, login to view] Admin) then hired the company who wrote it to customize it for my needs but they feel they have done the best they can do with the site but it is taking more than 60 seconds to load the home page ( www. localbizit .com ). I am guessing because it is looking through all 4 million records before loading the page for some reason.
I need someone who is more familiar with Mysql and PHP as I am a .net and sql guy myself.
I am guessing it will take less than 2-4 hours to write better querries for the site.