Slow product detail with 400 variants
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!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
- Posts: 44
- Joined: 05 Feb 2018, 09:57
Slow product detail with 400 variants
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.
other products with around 20 variants are OK.
Thanks.
Re: Slow product detail with 400 variants
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, give us a star
If you like Aimeos, give us a star
-
- Posts: 44
- Joined: 05 Feb 2018, 09:57
Re: Slow product detail with 400 variants
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.
any idea how we could improve this? loading it dynamically instead of locking the whole system for 20-30s?
Thanks.
Re: Slow product detail with 400 variants
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, give us a star
If you like Aimeos, give us a star
-
- Posts: 44
- Joined: 05 Feb 2018, 09:57
Re: Slow product detail with 400 variants
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
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, give us a star
If you like Aimeos, give us a star
-
- Posts: 44
- Joined: 05 Feb 2018, 09:57
Re: Slow product detail with 400 variants
I did, but it didnt help. still around 30s
Re: Slow product detail with 400 variants
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.
- 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, give us a star
If you like Aimeos, give us a star
-
- Posts: 44
- Joined: 05 Feb 2018, 09:57
Re: Slow product detail with 400 variants
I can already see some speed improvements in latest version.
-
- Posts: 44
- Joined: 05 Feb 2018, 09:57
Re: Slow product detail with 400 variants
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 (112.58 KiB) Viewed 6631 times