Author Topic: Random Product module very slow with 8k products  (Read 2694 times)

nflmerch

  • Jr. Member
  • **
  • Posts: 114
Random Product module very slow with 8k products
« on: January 20, 2012, 00:43:36 am »
VM2 & J1.7
My site has over 8,000 products and the Random Product module makes the page load very slow.   If I try the same site with only the sample products, and the module works fine and the page loads fast.  My VM1 site's random product module with the same products also works fine.   Perhaps it's a scalability issue.

Right now, for example on http://nflmerch.com/test/nfl/chicago-bears , I have the module's category filter on, so the page loads just fine and fast.  As do any of the category pages, due to the category filter.
However, if you navigate to any page that's NOT a category, it attempts to pull random products from all 8,000 and the page then loads very slow.   Try the search function or customer service page, for example.

Thanks for your input


nflmerch

  • Jr. Member
  • **
  • Posts: 114
Re: Random Product module very slow with 8k products
« Reply #1 on: February 10, 2012, 00:18:19 am »
I still have this problem with the latest version 2.0.1.e
It leads me to believe there is a scalability issue with VM2 that was not in VM1 !

1.  8,000 products and 16,000 images
2.  Worked well with VM1 !  (you can go the the root URL of my link to see my VM1 site working fast, on same server and sql server)
3.  Product module "Use Category Filter" set to ON
4.  Any category page, or product detail page, loads fine and fast.
5.  Any page NOT a category page or VM page loads very slow.  (Due to the fact the category filter doesn't apply on those pages)

I did a new test install since my last post, so here's a new link: http://nflmerch.com/new15/shop/arizona-cardinals


Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10087
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Random Product module very slow with 8k products
« Reply #2 on: February 10, 2012, 00:35:41 am »
Interesting thing, I think it is solvable. Please provide me more information, what you mean with "5.  Any page NOT a category page or VM page loads very slow.  (Due to the fact the category filter doesn't apply on those pages)"
you have my number you also can call me.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

nflmerch

  • Jr. Member
  • **
  • Posts: 114
Re: Random Product module very slow with 8k products
« Reply #3 on: February 10, 2012, 00:58:56 am »
what you mean with "5.  Any page NOT a category page or VM page loads very slow.  (Due to the fact the category filter doesn't apply on those pages)"
Check my link and go to a link that is NOT a VM category page.  Such as "Order Tracking".   Since I have the Category Filter ON,  category pages are fast, but any page that is NOT a category like "Order Tracking" is very slow because then it is choosing for 8,000 products instead of just a couple hundred from the selected category

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10087
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Random Product module very slow with 8k products
« Reply #4 on: February 10, 2012, 11:21:55 am »
Hmmm, for me every page is quite fast (approximatly the typical 1 sec). But random module is deactivated.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

nflmerch

  • Jr. Member
  • **
  • Posts: 114
Re: Random Product module very slow with 8k products
« Reply #5 on: February 10, 2012, 22:46:12 pm »
Hmmm, for me every page is quite fast (approximatly the typical 1 sec). But random module is deactivated.
Sorry if you didn't see, but I posted a new link in my second post:
http://nflmerch.com/new15/shop/arizona-cardinals