Excessive Mysql queries and Mambo

[ergo]

maybe they should switch off some unnesseary modules from mambo ? hm... i thought mambo was well written...

[sdjl]

It doesn't matter how well written a piece of software is, the fact is, if your website gets busy then load starts to increase as more queries for data are being processed.
The only way to combat this is to incorporate some kind of caching system.

David

[ThomasW]

There is a thread about an account getting locked out on the Joomla forums, looks like it was caused by a query happy 3rd party module.

Just out of curiosity I did some testing of a few Joomla sites I run and the average number of queries was in the upper 30's to 40's for most pages.
One site's homepage did generate 111 queries, but when I turned on caching it dropped to 45.

I usually install modules on a test system just to see how it works and if it slows the webserver down much, it is just a good idea to test a little before putting it to use.

[ergo]

lol 45 queries this software is crappy then, i have about 15 queries generated on my site and i think its too much, and looking for a way to optimise it....

[Buddha]

Just out of curiosity I did some testing of a few Joomla sites I run and the average number of queries was in the upper 30's to 40's for most pages.
One site's homepage did generate 111 queries, but when I turned on caching it dropped to 45.

For every MyISAM table there's three files so 3 time 30-111 queries equals a lot of disk activity.

I usually install modules on a test system just to see how it works and if it slows the webserver down much, it is just a good idea to test a little before putting it to use.

Excellent advice.

[AndrewT]

That's exactly the problem with these CMS scripts. 30-40 queries is still a lot for a single page and most of it is not really needed or used by the site running the script. Add a fair amount of visitors to the site and it suddenly becomes a problem.

[ergo]

heh a simple cms website can use 5 queries of less if its written to do exacly what are client needs mostly... ill be changing my portal's code and my db class will be counting queries, well se what will get :]

[james]

My advice: you should really use this as an opportunity to charge them more for hosting!

A similar thing happened to a site I was hosting, and in the end I charged them more by saying I would move their site to a different server. I now host their site through another web host using a very small shared hosting account there. This way they see you as being pro active in solving their problem, and you also make more money off them.

[ergo]

My advice: you should really use this as an opportunity to charge them more for hosting!

A similar thing happened to a site I was hosting, and in the end I charged them more by saying I would move their site to a different server. I now host their site through another web host using a very small shared hosting account there. This way they see you as being pro active in solving their problem, and you also make more money off them.

i wuldnt go for this kind of argumentation, i would change my host :] if i'd have to pay more i would like to have better specs for my account

[ergo]

For every MyISAM table there's three files so 3 time 30-111 queries equals a lot of disk activity.

im not sure if mysql uses all 3 files for reading. anyway its more important sometimes how a query is written instead of how meny we use.
using ORDER BY RAND() , can be a killer to database if there is lots of rows to process. but split into 2 queries can be even 1000x faster for big tables( according to jan kneshkes benchmarks - kneshke works for mysql ).

[Buddha]

im not sure if mysql uses all 3 files for reading.

Nope, it probably doesn't and I was pointing out the worst case. On a shared server, disk operations are costly. Chances of hitting any in memory data cache heads to zero as traffic peaks on a shared server and that can bring a site to a grinding halt.

anyway its more important sometimes how a query is written instead of how many we use.

True.

My advice: you should really use this as an opportunity to charge them more for hosting!

I like that idea.

[sdjl]

Just a note here, WordPress 2 is also rather query hungry.
I've been rather dissapointed with it so far. It uses on average 25 - 35 queries on the main index page and around 20 on single post pages.

David

[ZYV]

Wpheewww.. I just wanted to recommend WordPress as a blog software of my choice to my sister to host on Dathorn. Would you please recommend a less query-intensive blogging software having all those WordPress's bells and whistles?

[ergo]

the best solution is to write a custom one yourself ... really.

[ZYV]

Sorry, don't have time for that. I have found an advanced cache for WordPress, which makes it comsume about 15 queries per page the first time, then no queries at all after the page gets cached