Author Topic: speed - Do you have "Show the Number of Products?" enabled?  (Read 1111 times)

stinga

  • Contributing Developer
  • Full Member
  • *
  • Posts: 872
    • Squangle ltd
speed - Do you have "Show the Number of Products?" enabled?
« on: March 20, 2010, 18:05:04 pm »
G'day all,

Not sure what difference this makes really, but by disabling this I dropped 400 DB queries which seems to be a lot to me.

You decide whether it is a 'nice to have' or a 'useful feature', I have put it in the 'nice to have' group and therefore it can be dropped.

It would better if this total were help in the category table and could be incremented/decremented when products are added/deleted/modified then we wouldn't need to extra 400 queries (in my case).
Stinga.
614869 products in 747 categories with 15749 products in 1 category.
                                             Document Complete   Fully Loaded
                Load Time First Byte Start Render   Time      Requests      Time      Requests
First View     2.470s     0.635s     1.276s          2.470s       31            2.470s      31
Repeat View  1.064s     0.561s     1.100s          1.064s       4             1.221s       4