Author Topic: No. of database queries? 800 is that normla?  (Read 1124 times)

gtech

  • Beginner
  • *
  • Posts: 46
    • Suknie slubne
No. of database queries? 800 is that normla?
« on: February 17, 2011, 17:24:41 pm »
Hi,
I have a  website:
www.i-slubny.pl
It generates around 800 database queries on front page. Is that normal?
SH404SEF installed


Site has around 600 unique visits a day and around 5000 page views.
I love what I do  - I do www
Suknie Slubne Suknie Wieczorowe

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10400
  • VirtueMart Version: 3+
Re: No. of database queries? 800 is that normla?
« Reply #1 on: February 17, 2011, 22:02:52 pm »
This page has 9 external Javascript scripts. Try combining them into one.
This page has 6 external stylesheets. Try combining them into one.
This page has 49 external background images. Try combining them with CSS sprites.

933k on category pages.



J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

gtech

  • Beginner
  • *
  • Posts: 46
    • Suknie slubne
Re: No. of database queries? 800 is that normla?
« Reply #2 on: February 22, 2011, 17:13:36 pm »
Thank you for your answer but that is not what i have asked.
800 queries to database is it normal? What is average number?
I love what I do  - I do www
Suknie Slubne Suknie Wieczorowe

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10400
  • VirtueMart Version: 3+
Re: No. of database queries? 800 is that normla?
« Reply #3 on: February 22, 2011, 17:14:41 pm »
sounds right to me, but your slowness problems are not the database

J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

gtech

  • Beginner
  • *
  • Posts: 46
    • Suknie slubne
Re: No. of database queries? 800 is that normla?
« Reply #4 on: February 23, 2011, 15:56:46 pm »
BanquetTables.pro
Thank you. I have just checked few other posts about number of queries and it seams that 800 is normal. What I have not spotted earlier is legacy queries along side with normal queries ( 800 normal queries + 800 legacy)
I have turned on legacy plugin and number of queries is down now to 4 ( happy day)
Thank you a lot for your help.
I love what I do  - I do www
Suknie Slubne Suknie Wieczorowe