Tue, 1st July 2014
Thank you for your feedback. If we are not mistaken and are talking about the same website, there are certain basic things that you have to take into consideration when planning for a big project. At a very minimum, you should have a good server that at least meets the minimum requirements, and better still, far exceeds these minimum requirements.
For MySQL to go through thousands of categories and subcategories, it takes up a lot of server memory and CPU. The only way of dealing with this issue is to set up caching on server and perform other server-side optimization tasks. Such tasks include fine-tuning services, optimizing RAM use, and configuring the server properly.
Things like server-side caching cannot be included into the product and have to be configured on the server. What we can do, and have spent considerable time working on this request, is set up server-side caching specifically on your server. After about half a year of going through endless changes of requirements (two project requests evaluated free of charge with dozens of manhours on each one), you never gave us a chance to actually do something and get your project going.
Stuffing the off-the-shelf product with tons of categories, putting it on the cheapest server possible and not even willing to consider having us set up caching to speed up the page load is not the avenue to success. Huge websites like eBay or Craigslist invest millions of dollars into running state-of-the-art heavy load server clusters, and you are trying to achieve the same on a single server and avoid spending a dime on fine-tuning even that poor machine to optimize it. Craigslist must be out of their minds spending more than $500 on their solutions, true pros can run a worldwide service for less.