Virtuemart admin very slow load

[roman5527]

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

[Jörgen]

That is a lot of categories-

When started this ?

New install ?

New plugin or extension ?

Added categories and extensions ?

Php version ?

Jörgen

[stAn99]

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

[roman5527]

Hi, when i disable optimise DB query in settings VM - its work .