Author Topic: Virtuemart admin very slow load  (Read 179 times)

roman5527

  • Jr. Member
  • **
  • Posts: 172
Virtuemart admin very slow load
« on: November 04, 2020, 14:56:53 pm »
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

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3131
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Virtuemart admin very slow load
« Reply #1 on: November 04, 2020, 15:38:30 pm »
That is a lot of categories-

When started this ?

New install ?

New plugin or extension ?

Added categories and extensions ?

Php version ?

Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

stAn99

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 88
    • One Page Checkout for Virtuemart 2
Re: Virtuemart admin very slow load
« Reply #2 on: November 04, 2020, 15:45:29 pm »
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
----
RuposTel.com
www.rupostel.com
Your customized checkout solution for Virtuemart

roman5527

  • Jr. Member
  • **
  • Posts: 172
Re: Virtuemart admin very slow load
« Reply #3 on: November 04, 2020, 17:17:23 pm »
Hi, when i disable optimise DB query in settings VM - its work .