03-04-10, 07:26
|
|
vaguely human
|
|
Join Date: Jun 2007
Location: London
Posts: 2,519
|
|
Quote:
|
Originally Posted by demods
first let me again say that this is not my script. This is, indeed, an open source script from Ajax IM.
|
It might be worth pointing the authors at this thread then. It wouldn't take much to improve things. You could even suggest they provide some example SQL to actually use the tables!
Quote:
|
Originally Posted by demods
I'm looking for a solution with the original query, because I really don't know what side-effects of your query will be.
|
The simple thing would be to test the results of your original query against the results of the new query for various user names. If the results are the same then you should be able to just replace the SQL directly with no worries. Remember that the my query doesn't include the admin user but that was just because I couldn't see why it should. If you want to try and improve your original SQL then just Google for "MySQL performance tuning" and just devote some time to study the pages returned.
Quote:
|
Originally Posted by demods
You are right at some points.
|
I must be loosing my touch 
|
|