Slow loading Wishlists

[kyleS2D]

In our store we have several users with wishlists of 60 or more items. It seems once a list starts to approach that size that the list page loads very slowly.

We are using AbleCommerce GoldR9 (build 7670).

Does anyone have recommendations for increasing the page load speed for wishlists?

[AbleMods]

define "very slowly". 2-3 seconds? 7-8 seconds? 30 seconds?

I tested a Gold R11 install and loaded up 84 items into wishlist. Page load speed for the wishlist page was 1.6 seconds. None of the products had inventory turned on, and none of the products were kits. So it may not be entirely apples-to-apples comparison. If you've got large kit setups or substantial variant grids build, that could have an impact on page speed.

I looked to see if there was index I could help you make, but both Wishlist tables have all the necessary indexes already.

Very, very little has changed in the wishlist area for several versions.

[kyleS2D]

On average they take around 12 seconds to load once they reach that size. Our developer and host "rebuilt the indexes" on our database this morning to address a similar issue with search results, and it seems to have fixed the issue with Wishlists as well.The developer said he saw that there was a difference between queries made by admins and queries made by users that was causing search result pages to load more slowly for clients than admins.

[AbleMods]

Sounds like your developer has things well covered. SQL Profiler is a great tool for analyzing database activity and optimizing the index structure for your specific needs.