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, 555 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Who is Online / User Info Block SQL Performance
Bug FixesLaffer writes "If you are using the WHO IS ONLINE / User Info Block on your website, you should monitor the Server Load, because this block contains a very bad SQL Select string.

In order to Display the Members who have registered Yesterday the SQL Select consist of a WHERE clause containing LIKE '%' Wildcards to replace the space characters in the date string.

If you take the SELECT and run in mysql the EXPLAIN command, you will see that this query can NOT use any index. This is because of the WILDCARD. You should replace the '%' wildcards with real SPACES (you have to use String Length Functions to adjust the number of spaces dependeng if the day is one or two digits) in order to use the INDEX. This speeds up the query on big user tables with a factor of at least 10x....!!!

You find a modified version at http://www.comicfan.de/modules.php?name=Downloads&d_op=getit&lid=59"
Posted on Tuesday, August 26 @ 23:55:00 CEST by Zhen-Xjell
 
Related Links
· More about Bug Fixes
· News by Zhen-Xjell


Most read story about Bug Fixes:
Downloads & Web Links vulnerability Patch

Article Rating
Average Score: 5
Votes: 2


Please take a second and vote for this article:

Excellent
Very Good
Good
Regular
Bad


Options

 Printer Friendly Page  Printer Friendly Page

 Send to a Friend  Send to a Friend

Threshold
The comments are owned by the poster. We aren't responsible for their content.

No Comments Allowed for Anonymous, please register

Re: Who is Online / User Info Block SQL Performance (Score: 1)
by dsnail2000 on Wednesday, August 27 @ 00:14:31 CEST
(User Info | Send a Message) http://www.controlbooth.com
will this fix be in the beta cvs?



Re: Who is Online / User Info Block SQL Performance (Score: 1)
by skully on Wednesday, August 27 @ 14:28:51 CEST
(User Info | Send a Message) http://www.aibo-friends.com
I get faster responses as promised, very good.
But i also fake PM messages.
All my visitors have many unread messages while there is no message in their inbox.

Any idee??

Robert
www.aibo-friends.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.098 Seconds - 227 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::