Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
Steptoe
Involved
Involved


Joined: Oct 09, 2004
Posts: 293

PostPosted: Wed Mar 08, 2006 5:24 pm Reply with quote

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 
View user's profile Send private message
VinDSL
Life Cycles Becoming CPU Cycles


Joined: Jul 11, 2004
Posts: 614
Location: Arizona (USA) Admin: NukeCops.com Admin: Disipal Designs Admin: Lenon.com

PostPosted: Wed Mar 08, 2006 5:38 pm Reply with quote

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!" ::.
.:: Only registered users can see links on this board! Get registered or login! | Only registered users can see links on this board! Get registered or login! ::. 
View user's profile Send private message Visit poster's website ICQ Number
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9456
Location: Arizona

PostPosted: Wed Mar 08, 2006 5:49 pm Reply with quote

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

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
VinDSL
PostPosted: Wed Mar 08, 2006 6:07 pm Reply with quote

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

Image


Last edited by VinDSL on Wed Mar 08, 2006 6:09 pm; edited 1 time in total 
montego
PostPosted: Wed Mar 08, 2006 6:09 pm Reply with quote

Bang Head Bang Head Bang Head Bang Head Bang Head Bang Head Bang Head

I need a Bart Simpson wave file right now...
 
Steptoe
PostPosted: Wed Mar 08, 2006 7:43 pm Reply with quote

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
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©