Author |
Message |
Steptoe
Involved
Joined: Oct 09, 2004
Posts: 293
|
Posted:
Wed Mar 08, 2006 5:24 pm |
|
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 |
_________________ My Spelling is NOT incorrect, it's Creative |
|
|
|
VinDSL
Life Cycles Becoming CPU Cycles
Joined: Jul 11, 2004
Posts: 614
Location: Arizona (USA) Admin: NukeCops.com Admin: Disipal Designs Admin: Lenon.com
|
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! ]
...and this page:
[ Only registered users can see links on this board! Get registered or login! ] |
_________________ .:: "The further in you go, the bigger it gets!" ::.
.:: VinDSL's Lenon.com | The Disipal Site ::. |
|
|
|
montego
Site Admin
Joined: Aug 29, 2004
Posts: 9457
Location: Arizona
|
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. |
_________________ Where Do YOU Stand?
HTML Newsletter::ShortLinks::Mailer::Downloads and more... |
|
|
|
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. |
Yes, this is true also!
Sometimes a picture is worth 1000 words, yes?
|
Last edited by VinDSL on Wed Mar 08, 2006 6:09 pm; edited 1 time in total |
|
|
|
montego
|
Posted:
Wed Mar 08, 2006 6:09 pm |
|
I need a Bart Simpson wave file right now... |
|
|
|
|
Steptoe
|
Posted:
Wed Mar 08, 2006 7:43 pm |
|
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 |
|
|
|
|
|