Author Topic: 70 Categories 20 Products = 30secs per page load - Why?  (Read 1972 times)

SuitedScooter

  • Beginner
  • *
  • Posts: 5
70 Categories 20 Products = 30secs per page load - Why?
« on: September 16, 2010, 01:11:02 am »
Hey there,

I'm very much into self-help, but on this occasion, I need a little bit of guidance on "where I should start to investigate".

I've just completed a new installation of Joomla 1.5, VM 1.1.5 and CSVI.

My site works great and browsing is sweet when viewing normal articles.
The moment I import my categories (70+) and add 5 products to 3 or 4 of the categories (therefore only 20 products loaded in 70 categories), browsing the categories takes 20 - 40 secs per categories.

Let me try to explain this a bit better....
I imported the categories and then started importing my products. Initially, I thought I would just import a few products and see how things looked and worked. So with 70 categories loaded and only 3 or 4 of them with products, the moment you click on a category with products, browsing dies.

Clicking on a category that is empty loads"just like that".

Is this a fault with my hosting? With the database? With VirtueMart or maybe with CSVI.

Since there are four possible areas, I'm really unsure where to start looking for the solution.

www.ticg.co.nz/index.php  (try clicking on LCD Monitors)(one of the few categories with products).

Thanks for any help and guidance.

SuitedScooter

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27766
  • Always on vacation
    • Jenkin Hill Internet
Re: 70 Categories 20 Products = 30secs per page load - Why?
« Reply #1 on: September 16, 2010, 10:40:02 am »
Which version of VirtueMart?
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.8.4.10335 on Joomla 3.9.19 PHP 7.3.18

SuitedScooter

  • Beginner
  • *
  • Posts: 5
Re: 70 Categories 20 Products = 30secs per page load - Why?
« Reply #2 on: September 17, 2010, 01:44:11 am »
Your VirtueMart version: VirtueMart 1.1.5 stable [Wiesbaden].

Flicking through some of the other posts, I see that SEF is an issue, however I have never (to the best of my knowledge activated SEF, so unless it is "on" as default, that shouldn't be the cause.

SuitedScooter

  • Beginner
  • *
  • Posts: 5
Re: 70 Categories 20 Products = 30secs per page load - Why?
« Reply #3 on: September 17, 2010, 02:24:34 am »
I just found this post that may apply to me (I too am new to VM).

Quote
I had the same problem, and today found a solution.

Problem was not with Mynxx theme.
Problem was not with double queries.

I found that, when I using FullImages as URL-s (not local images) then virtualmart downloads all FullImages (not thumbnails) and checks their dimensions.

I simply commented 3 lines in "shop.browse.php" file:


$product_full_image = IMAGEURL . 'product/' . $product_full_image;
      } elseif( !isset( $full_image_width ) || !isset( $full_image_height ) ) {
         // This is a URL image
    /**      $full_image_info = @getimagesize( $product_full_image );
         $full_image_width = $full_image_info[0]+40;
         $full_image_height = $full_image_info[1]+40;     **/
      }

This came from this thread: http://forum.virtuemart.net/index.php?topic=69341.0

When I use CSVI, one of my fields that I import is (eg: http://www.dove.co.nz/assets/images/product/3665-449202.jpg)

These jpg files are hosted on my supplier's server, so maybe this is the cause?
If so, what would be the best way for me (and my website) to get images to load (since they don't at the moment anyway).

SuitedScooter

  • Beginner
  • *
  • Posts: 5
Re: 70 Categories 20 Products = 30secs per page load - Why?
« Reply #4 on: September 17, 2010, 03:11:11 am »
Well, ok, that worked nicely. Sweet....

Right.... now I need to sort out the images no appearing in the first place. What options are available to me in relation to giving my VM some product images now that I have commented out those three lines?

Thanks in advance

SuitedScooter

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27766
  • Always on vacation
    • Jenkin Hill Internet
Re: 70 Categories 20 Products = 30secs per page load - Why?
« Reply #5 on: September 17, 2010, 10:29:57 am »
I have no idea about this. I do not link to remote images, using local copies always. This avoids problems with resizing, with speed and when an image url changes.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.8.4.10335 on Joomla 3.9.19 PHP 7.3.18