Hi, i have problem with very slow load categories and products in virtuemart admin .
When i click to categories in admin menu Virtuemart i waith 5 - 10 minutes until they appear to me categories or products.
i have 2951 categories .
can i fix this problem thanks.
I have Joomla 3.9.22 and VM 3.8.4 10335
That is a lot of categories-
When started this ?
New install ?
New plugin or extension ?
Added categories and extensions ?
Php version ?
Jörgen
i suggest to try:
- disable sql optimize queries in VM config (as this does updates while there is heavy selects at frontends)
- switch all VM tables to InnoDB engine (since mysisam blocks whole table during udpate/insert and innodb locks just related rows)
- disable chosen library at backend (via some javascript unsetting plugin)
let us know what helped it.
best regards, stan
Hi, when i disable optimise DB query in settings VM - its work .