You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 360 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - User Info Block slowing site down... [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
ryanrbftp
Private
Private


Joined: Aug 08, 2003
Posts: 43


PostPosted: Tue Sep 28, 2004 9:10 am Reply with quoteBack to top

I've recently noticed that my User Info block is slowing my site down, I get on average 1.2 second page generation times when their is roughly 350 people currently online - when I disable User Info, I cut this in half! Their are too many database queries to check the users online. Where can I get a newer block without the users online info on, but still the rest of the info? You can see my current block at http://flyawaysimulation.com
Find all posts by ryanrbftpView user's profileSend private messageVisit poster's website
ryanrbftp
Private
Private


Joined: Aug 08, 2003
Posts: 43


PostPosted: Tue Sep 28, 2004 9:11 am Reply with quoteBack to top

Also, If the users online is to be removed, how can I set the forums up to show who's online for the WHOLE site - not just the forums? I'm talking about the bit at the bottom of the forums index: http://flyawaysimulation.com/forums.html

Any ideas?
Find all posts by ryanrbftpView user's profileSend private messageVisit poster's website
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283


PostPosted: Mon Oct 04, 2004 9:16 pm Reply with quoteBack to top

ryanrbftp wrote:
I've recently noticed that my User Info block is slowing my site down, I get on average 1.2 second page generation times when their is roughly 350 people currently online - when I disable User Info, I cut this in half! Their are too many database queries to check the users online. Where can I get a newer block without the users online info on, but still the rest of the info? You can see my current block at http://flyawaysimulation.com


There are some serious queries going on in the user info block. I see a few solutions:

(a) make sure mysql query cache is on (which is the default), and is properly working in this case.

(b) cache the query results, and don't update it on every page. Something like "cachelite" will do. Easy to install. You can search for it on this site.

_________________
ezClassifieds|Forums:Auto,Mac,Job,Win,HW
Find all posts by steven111View user's profileSend private messageVisit poster's website
luchtzak
Support Mod
Support Mod


Joined: Mar 19, 2003
Posts: 308


PostPosted: Wed Oct 06, 2004 12:51 pm Reply with quoteBack to top

Ryan already contacted me and I made him a reduced userinfoblock. All works fine again he assured me Wink

_________________
Luchtzak Aviation - Snookerforum Belgium
Find all posts by luchtzakView user's profileSend private messageVisit poster's website
ryanrbftp
Private
Private


Joined: Aug 08, 2003
Posts: 43


PostPosted: Fri Oct 08, 2004 9:16 am Reply with quoteBack to top

Yes Bart, your block worked just great, gen times cut in half! Many thanks. Maybe we can post the code on here for others to use?
Find all posts by ryanrbftpView user's profileSend private messageVisit poster's website
Slapyo
Nuke Soldier
Nuke Soldier


Joined: Feb 23, 2004
Posts: 12


PostPosted: Thu Oct 28, 2004 9:25 am Reply with quoteBack to top

i'd be interested in this code.
Find all posts by SlapyoView user's profileSend private message
ryanrbftp
Private
Private


Joined: Aug 08, 2003
Posts: 43


PostPosted: Mon Nov 08, 2004 8:58 am Reply with quoteBack to top

Slapyo wrote:
i'd be interested in this code.


The code for the cut down user info block? You can see it in action at http://flyawaysimulation.com Is this what you are looking for? I'll paste the code on - let me know.


Last edited by ryanrbftp on Fri Nov 12, 2004 7:46 am; edited 1 time in total
Find all posts by ryanrbftpView user's profileSend private messageVisit poster's website
telli
Support Mod
Support Mod


Joined: Aug 21, 2003
Posts: 335


PostPosted: Mon Nov 08, 2004 12:16 pm Reply with quoteBack to top

No need to sacrifice your information in the block just get a block that doesnt dip into the database 3 times for each user. My block is super optimized and you dont lose any of the features. Try it out can't hurt. Right now I have well over 200 people online 20 of which are registered users and my block is creating about 10 queries.

http://www.codezwiz.com/downloadview-details-336-CZUser-Info_block_V4.html

_________________
[img]http://www.codezwiz.com/extern.php?get=sig[/img]
http://www.codezwiz.com
PHPNuke Themes
$3.99 500 MB Storage & 20 GIG Trans w/ NO limit MYSQL
Click Me
Find all posts by telliView user's profileSend private message
Slapyo
Nuke Soldier
Nuke Soldier


Joined: Feb 23, 2004
Posts: 12


PostPosted: Thu Nov 18, 2004 8:13 pm Reply with quoteBack to top

ryanrbftp wrote:
Slapyo wrote:
i'd be interested in this code.


The code for the cut down user info block? You can see it in action at http://flyawaysimulation.com Is this what you are looking for? I'll paste the code on - let me know.

yes please. Smile thanks!!

telli wrote:
No need to sacrifice your information in the block just get a block that doesnt dip into the database 3 times for each user. My block is super optimized and you dont lose any of the features. Try it out can't hurt. Right now I have well over 200 people online 20 of which are registered users and my block is creating about 10 queries.

http://www.codezwiz.com/downloadview-details-336-CZUser-Info_block_V4.html

i will check out your block as well telli.
Find all posts by SlapyoView user's profileSend private message
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next 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



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.052 Seconds - 241 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::