I have a business directory script called phpmydirectory. I am looking for someone to optimize the database structure and code access the database. Also set up proper indexing. for example LEFT JOIN in query rather than the way it queries using PHP to correlate them. Also setting up proper indexing for the database. Or providing a different more efficient business directory script with the same or better features that is set up to handle up to 14 million listings.
At this time I have removed all but a a few thousand listings because of the slowness. Once I get up around a few hundred thousand it slows way down. I have checked with the host company. It is not the server rather the items described above.
Here is a link to the current directory.
[url removed, login to view]