Page Speed and db Calls?

Steptoe · Involved Joined: Oct 09, 2004 Posts: 291

This is a general question.
I Believe(?) the more calls a page makes from the db the slower the page??
If say a block...eg a scrolling forum block is being tested on a site (left side) and is set to veiw admin only, when a visitor goes to the page does it sill call from db even thu they cant see it?
Same for a module..eg if MSA is only ADMIN veiw?

Also if say a scrolling forum block has things like time taken out of the time/date link to posters details removed does that speed it up loading

I know these MAY very well be small time differences, just curious

VinDSL · Posted: Wed Mar 08, 2006 5:38 pm

Steptoe wrote:

This is a general question.
I Believe(?) the more calls a page makes from the db the slower the page??... I know these MAY very well be small time differences, just curious

Yes, this is true -- no doubt about it -- and the time differences can be quite dramatic.

I have a script in the footer on my production site that shows page gen times, query count, server load, yada, yada, yada...

Look at the difference. for instance, between this page:

Only registered users can see links on this board!
Get registered or login to the forums!

...and this page:

Only registered users can see links on this board!
Get registered or login to the forums!

montego · Posted: Wed Mar 08, 2006 5:49 pm

Quote:

If say a block...eg a scrolling forum block is being tested on a site (left side) and is set to veiw admin only, when a visitor goes to the page does it sill call from db even thu they cant see it?
Same for a module..eg if MSA is only ADMIN veiw?

Steptoe, since these modules are not viewable to the non-admin, no, they would not produce the SQL calls. The blocks are not even "executed".

I just wanted to address that specific set of questions. Wink

VinDSL · Posted: Wed Mar 08, 2006 6:07 pm

montego wrote:

Steptoe, since these modules are not viewable to the non-admin, no, they would not produce the SQL calls. The blocks are not even "executed".

I just wanted to address that specific set of questions. Wink

Yes, this is true also!

Sometimes a picture is worth 1000 words, yes? Very Happy

montego · Posted: Wed Mar 08, 2006 6:09 pm

I need a Bart Simpson wave file right now...

Steptoe · Involved Joined: Oct 09, 2004 Posts: 291

Cool thanks guys...I just wanted to make sure what I thought was right was actually correct.
It was difficult to tell as /I hit my server on 100meg lan connection, the times do vary but not enough to confirm a difference