Ok, tell me I'm trying to squeeze a quart into a pint pot...
I have 310,000 products loaded. They are all in one category. This is the entire Yamaha outboard spare parts list. I'm about to add another 200k+ items from other manufacturers, but won't until I've solved this one. This will be a very simple site. Type your part number into the search, then place it in your basket.
However, it takes 26 seconds to retrieve a part's details, so it's kinda doomed before it starts! If I click on the Yamaha manufacturer link, it times out on the browser.
It's hidden, but if anyone wants to try the dev site, it's now publicly viewable for a while at http://yamSpares.kingsmarine.co.uk/yamSpares.
Try a search for 6E0443520000
I've tried looking through the advanced_search.php file, as I can get away with limiting the search to just the model field. However, I think there's more to it than that!
Any help much appreciated.
Bookmarks