Author Topic: Slow database queries  (Read 587 times)

roman5527

  • Jr. Member
  • **
  • Posts: 155
Slow database queries
« on: November 05, 2018, 20:04:02 pm »
Hi, i see two weeks back on my hosting console , slow queries on database :

i see log which contains queries how : /you can see in file


problem is : I see many times error 502 or 503 on my site.

Does anyone have any idea where the problem might be?

thanks

2dmaster

  • Jr. Member
  • **
  • Posts: 97
Re: Slow database queries
« Reply #1 on: November 05, 2018, 21:17:57 pm »
In new update sql high load error fixed, try dev.virtuemart.net

2dmaster

  • Jr. Member
  • **
  • Posts: 97
Re: Slow database queries
« Reply #2 on: November 05, 2018, 21:36:15 pm »

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9943
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Slow database queries
« Reply #3 on: November 06, 2018, 00:10:12 am »
Hello roman,

replace in the product model around line 698
Code: [Select]
$where[] = ' p.`virtuemart_product_id`!='.implode(' AND p.`virtuemart_product_id`!=',self::$_alreadyLoadedIds).' ';

against
Code: [Select]
$where[] = '   ( p.`virtuemart_product_id` NOT IN ('.implode(',',self::$_alreadyLoadedIds).') ) ';
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/