Author Topic: Performance grinds to a near halt when add product categories!?  (Read 950 times)

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9085
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Performance grinds to a near halt when add product categories!?
« Reply #15 on: March 24, 2017, 07:20:29 am »
the new core is also cached and optimised. It is quite likely that it will run faster, when you update. Alone the added keys may enhance your speed.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

xocigars

  • Beginner
  • *
  • Posts: 20
Re: Performance grinds to a near halt when add product categories!?
« Reply #16 on: March 24, 2017, 16:07:07 pm »
Thank-you Jenkihill and Milbo and Ghost,

One more question for now please:

As, I am currently in the throws of integration testing (and server 500 errors occur during debug), and is so slow for testing,
would you recommend upgrading to Joomla 3.6.5. but leave Virtuemart at 3.0.9, until my changes/testing is complete?

Kind regards,
Steve

xocigars

  • Beginner
  • *
  • Posts: 20
Re: Performance grinds to a near halt when add product categories!?
« Reply #17 on: March 24, 2017, 16:09:01 pm »
I can try to upgrade Virtuemart as well - is just such bad timing to have to do this right now..

xocigars

  • Beginner
  • *
  • Posts: 20
Re: Performance grinds to a near halt when add product categories!?
« Reply #18 on: March 24, 2017, 16:27:02 pm »
I suppose I could remove some category-products (seems silly but okay).

I noticed if I add all-products under the parent into the parent menu this really bogs it down.

I don't even really need to populate it, but it navigates when zero (0) products are loaded and says "Product not found" (same in mobile menu version..)

xocigars

  • Beginner
  • *
  • Posts: 20
Re: Performance grinds to a near halt when add product categories!?
« Reply #19 on: March 24, 2017, 16:30:50 pm »
(sorry, I meant parent-categories not parent menus)

xocigars

  • Beginner
  • *
  • Posts: 20
Re: Performance grinds to a near halt when add product categories!?
« Reply #20 on: March 24, 2017, 17:27:53 pm »
fyi.. Cutting down product-categories from 50,000 rows to 8184  - no (high-level menu) category-parent products loaded into vm_product_categories ,
shaved it to a 9-second load ...for every page.. getting there?! :)

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9085
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Performance grinds to a near halt when add product categories!?
« Reply #21 on: March 27, 2017, 13:56:12 pm »
I am sorry. You use an odd number 3.0.9,.. .unsecure one,... and so on.

"- no (high-level menu) category-parent products loaded into vm_product_categories "
I am not able to translate this. What the heck do you mean?

"shaved it to a 9-second load"
From? to, where? what? I can shave a beard. hmmm

"I suppose I could remove some category-products (seems silly but okay).
Categories controll a lot in vm, taxes, browseable and such things. I fear I do not understand what you mean, it could have side effects

"would you recommend upgrading to Joomla 3.6.5. "
Your pages is quite likely so slow, because it got already hacked. Any unpatched version older than j3.6.5 is hackable for any 16 year old without any tool.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

xocigars

  • Beginner
  • *
  • Posts: 20
Re: Performance grinds to a near halt when add product categories!?
« Reply #22 on: March 27, 2017, 15:01:25 pm »
e.g.

Size(10)
  |_ Small(5)
  |_ Medium(3)
  |_ Large(2)

Size(0)
  |_ Small(5)
  |_ Medium(3)
  |_ Large(2)

..is faster, takes 9 seconds for every page to load down from 12 (shaved 3 seconds off)

but now, if Users click the high-level Size (parent menu/category), which is still clickable when 0 products (seems silly), it returns, of course, "No result" (no products found) but it is faster.

I was simply trying to convey just a little more info in hope to resolve this - sorry for my cryptic sentences above.
Just saying removing products from vm_product_categories for the (high-level) parent category e.g. Size improves perfromance. I just don't get it. If it is indexed which it is..why so much slower for additional categories and/or parent categories?

I will try upgrading joomla to 3.6.5 today

thanks,
Steve


xocigars

  • Beginner
  • *
  • Posts: 20
Re: Performance grinds to a near halt when add product categories!?
« Reply #23 on: March 27, 2017, 15:05:11 pm »
fyi..my site isn't live in terms of still has a login screen (and administrator lock extension), I am trying to go-live but it is too slow.

Ghost

  • Jr. Member
  • **
  • Posts: 319
Re: Performance grinds to a near halt when add product categories!?
« Reply #24 on: March 28, 2017, 07:41:44 am »
Here is the console before the crash (attached .jpg)...db looks fine..

thx - Steve
You need to check this information on the slow page, not on random admin page.