Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

HIGH Volume of mySQL queries
(1 viewing) (1) Guest
Support forum for customers who have purchased this product with priority support pack. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: HIGH Volume of mySQL queries

HIGH Volume of mySQL queries 11 years, 10 months ago #30058

Hi there we have another issue - still trying to get to the bottom of the server load

when we enable SEF the query count is huge - see below

Profile Information
Application afterLoad: 0.001 seconds, 0.89 MB
Application afterInitialise: 0.160 seconds, 8.34 MB
Application afterRoute: 0.301 seconds, 12.61 MB
Application afterDispatch: 4.076 seconds, 29.09 MB
Application afterRender: 4.415 seconds, 30.66 MB
Memory Usage
32528896
515 queries logged

With SEF off its alot smaller -see below


Profile Information
Application afterLoad: 0.001 seconds, 0.89 MB
Application afterInitialise: 0.390 seconds, 5.94 MB
Application afterRoute: 0.652 seconds, 8.49 MB
Application afterDispatch: 5.976 seconds, 23.85 MB
Application afterRender: 6.253 seconds, 25.13 MB
Memory Usage
26653208
88 queries logged


Can you advise what may be causing this please
The topic has been locked.

Re: HIGH Volume of mySQL queries 11 years, 10 months ago #30082

  • dajo
  • OFFLINE
  • Posts: 5069
Hi,
The number of queries depends on how many URLs is displayed on the page - basically for each displayed URL JoomSEF makes a database request, unless the URL is already cached.
On websites with many URLs on one page this can cause performance issues, so we recommend also enabling the System - Cache plugin if it's possible - it caches whole pages, which can significantly increase performance. However it cannot be used for example with modules that display random images, since the page would be cached and aways show only one image.
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
User Login Empty