CODEWITHSUNDEEP
phpsqljoomlajoomla2.5
Efekan
Efekan

Reputation: 1505

Joomla executes over 2700 database queries

I'm new to Joomla 2.5 and have this problem. Joomla executes over 2700 database queries on the homepage. I have not even a single clue how it could execute so much.

Here is a picture of the homepage. The amount of queries: enter image description here




And this is the information page which only uses 109 queries (still a lot) enter image description here

Upvotes: 0

Views: 96

Answers (2)

Brent Friar
Brent Friar

Reputation: 10609

That is a ridiculous number of queries. Our home page with K2, a slideshow, a mega menu, 3 K2 modules, a search box, several custom HTML modules, and a Chronoforms module has a total of 73 queries.

Turn everything off then enable the modules and extensions one at a time until you find the problem extension. Once you have found the problem extension, uninstall it and get a replacement.

Upvotes: 1

Efekan
Efekan

Reputation: 1505

I've found the answer. The homepage was setup to show the virtuemart homepage. We put it so that it didn't show the virtuemart homepage but instead the one we made. So what the homepage did is load all the queries of virtuemart. We've put the menu item now to a blank page and the queries dropped by 2600. We've also enabled caching and that helped the site pretty much getting loaded in about 1.5 seconds.

Upvotes: 0

Related Questions