Slow screen refresh

[graphicz]

Is anyone else having issues with preview screen refresh time when using lots of filtering?
I have no javascripts etc etc enabled during preview, I have only found it an issue with a site using a great deal of filtering.

[peblaco]

I've been doing a lot of work with filtering and found a variety of problems. One problem is the way the loading graphic layer stays on screen until filtering completes which means you can't click anything, that's on the wish list reference WL-2939. Regarding slowness - do you mean preview within the software?. On the website where there are lots of products on the same page it can be slow. I've been sent some fixes by SellerDeck support including:
1) If you click around too fast during filtering loading it causes a syntax error, there is a fix available for actinicsearch.js for bug reference SD-2576 / Cancelled navigation with big filtering page causes parseJSON errors.
2) Slow filtering on server there is a fix available to the server to verify that the MIME map is enabled or add the MIME map, or if unable to make changes on shared hosting an alternative fix available for several scripts.
If these issues affect you then you could contact the support team for these.

[graphicz]

Thanks Louise

Yes, I meant the preview pane within the software

I am already in touch with support about an other filtering issue. I will run it on here when I can summarise it effectively.

Thanks again.

[peblaco]

I have got a slow preview on a site with filtering but the page in question has a lot of products anyway so I think it is more to do with the product numbers than the fact that filtering is enabled.

[graphicz]

Any upload isues? This site has loads of products and most sections populated by filtering and upload hangs for ages at checking html pages and checking catalog

[peblaco]

Not personally. Does it hang if you try to upload to a different host?.

[graphicz]

I have a bulk account (many Sellerdeck sites) with Heart and have no problems with them.

Other sites same computer and same hosting account go up fine.

[graphicz]

Slow upload due to multiple (and i mean multipl!) product duplicates. These have been removed by using this fix: http://community.sellerdeck.com/show...91&postcount=8

[Hugh Gibson]

I found a bug yesterday after Louise @ Peblaco reported some very slow previewing and uploading. Internal support reference was SUP-3146 and our internal bug reference is SD-2675.

If you use filtering and duplicate products, make sure you have products with Product Reference of "1", "2", "3" .... up to the max number of duplicates that you have of any one product.

So, if you have 5 duplicates of a given product, but no other products with more duplicates, create dummy products with references "1" through "5". You can hide these from the website; they just have to exist in the database.

The problem is caused by incorrect handling of duplicate product references. Internally these are stored like "1!1234" for the first duplicate of product "1234", "2!1234" for the second duplicate etc. The "1" and "2" are treated as full-blown product references and an attempt is made to load them from the database as they aren't in the cache. Obviously they fail to load from the database unless you've created dummy products. Repeated database calls soon add up.

That will have been the cause of the 20 minute upload time you saw, Jonathan. Eliminating duplicates eliminated the problem for you.

I would be very interested in knowing if others see a speed up after defining these dummy products. That will influence our planning progress.

[peblaco]

Thanks Hugh, I implemented this fix on the site in question and the preview window now loads sections with filtering enabled the same speed as sections without filtering enabled, check and send files and exporting a snapshot completed normally.