Slow product detail with 400 variants

Help for integrating the Laravel package
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
michal.fehér
Posts: 44
Joined: 05 Feb 2018, 09:57

Slow product detail with 400 variants

Post by michal.fehér » 05 Jul 2018, 20:10

Hi. Is it normal that it takes 28 seconds on average to load product detail in admin that has 400 variants? When I click the product, the detail is displayed immediately but the variant tab is shown only after 28 seconds.
other products with around 20 variants are OK.

Thanks.

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Slow product detail with 400 variants

Post by aimeos » 06 Jul 2018, 08:28

We haven't tried that much variants in the admin interface yet. Problem might be that the "Variants" tab is shown after the page is completely rendered by the browser. Was the tab shown faster in 2018.04 versions?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

michal.fehér
Posts: 44
Joined: 05 Feb 2018, 09:57

Re: Slow product detail with 400 variants

Post by michal.fehér » 06 Jul 2018, 11:09

in 2018.04 it takes around 17s which is much less but still a lot. this amount of variants is not that unusual in real world. having 3 variant attributes with 7 different options is quite common in our industry.
any idea how we could improve this? loading it dynamically instead of locking the whole system for 20-30s?

Thanks.

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Slow product detail with 400 variants

Post by aimeos » 06 Jul 2018, 11:44

I think that's mainly a rendering issue, maybe due to Vue.JS. Can you post a screenshot of the Chrome "Performance" tab of your browser console after recording a page reload of the detail page?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star


User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Slow product detail with 400 variants

Post by aimeos » 06 Jul 2018, 12:32

Like expected: There are ca. 35sec script execution time!

Could you please remove those lines and test again?
https://github.com/aimeos/ai-admin-jqad ... #L312-L315
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

michal.fehér
Posts: 44
Joined: 05 Feb 2018, 09:57

Re: Slow product detail with 400 variants

Post by michal.fehér » 06 Jul 2018, 13:14

I did, but it didnt help. still around 30s

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Slow product detail with 400 variants

Post by aimeos » 10 Jul 2018, 18:10

We did some tests with products containing 1000 variants:
- Plain HTML: 11sec
- Vue.JS with 1000 labels only: 12sec
- Vue.JS with 1000 variant boxes but no jQuery combo boxes inside: 20sec
- Vue.JS with 1000 variant boxes and jQuery combo boxes inside: 480sec

The real problem are the jQuery comboboxes, so we removed them for existing items (now you have to remove and add a new box or variant attribute): https://github.com/aimeos/ai-admin-jqad ... ef4bccbf66

There's still a performance problem in Vue.JS if you add a new box or variant attribute. It takes much longer than expected to add a new item to the end of the list. We will investigate that further together with the Vue.JS developers.

The only way to speed up rendering further is to remove data from the boxes and e.g. list the article codes only.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

michal.fehér
Posts: 44
Joined: 05 Feb 2018, 09:57

Re: Slow product detail with 400 variants

Post by michal.fehér » 16 Jul 2018, 11:56

I can already see some speed improvements in latest version.

michal.fehér
Posts: 44
Joined: 05 Feb 2018, 09:57

Re: Slow product detail with 400 variants

Post by michal.fehér » 30 Jul 2018, 16:48

Do you also plan to change logic for stock info? For products with large amount of variants it looks like this and it causes "414 URI too long" error on most of the server providers
Attachments
Snip20180730_11.png
Snip20180730_11.png (112.58 KiB) Viewed 3789 times

Post Reply