 |
|
 |
|
- Readme First! -
Read and follow the rules, otherwise your posts will be closed |
|
|
|
|
|
There are currently, 374 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 |
|
 Laffer 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 |
|
|
|
|
| |
|
Average Score: 5
Votes: 2
|
|
|
|
|
|
|
| | 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 Zhen-Xjell on Wednesday, August 27 @ 09:53:09 CEST
(User Info | Send a Message) http://castlecops.com | Yes I'll look into this... can you drop it in here?
http://bugs.nukecops.com/ |
]
| | | | |
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 |
| | | | | |
|
