I have a site at [url removed, login to view] which is based on Prestashop 1.4.6 which is causing problems. The site currently has 40,198 products but only 18568 are indexed for search. "Add missing products to index" doesn't seem to have any other effect than to cause the admin page to hang. Meanwhile, on the front end of the store, users searching for products are faced with a ridiculous delay in seeing results - the site effectivley becomes unusable. The rest of the site seems to be running at an acceptable speed. Memcached is enabled and working, and "Force Compile" is set to off. I'm looking for someone with previous experience of this who can resolve it quickly.