John Ragan wrote:
Im running the following query:
SELECT
user.nickname,
user.id,
user_detail.points
FROM
user,
user_detail
WHERE
user.details = user_detail.id
AND user.id > 101
AND user.language = 'en'
ORDER BY user_detail.points DESC
LIMIT 5;
I don't really know how LEFT JOINS, INNER JOINS and so on work, but I want
to increase the performance of the query.
This is the result of the EXPLAIN for the query:
if you would like to learn more about queries and
if you have a windows box for a front end,
download corereader from http://corereader.com
it will let you quickly do and re-do join queries
just by clicking on your database objects, so you
can concentrate on developing logic without
worrying about syntax. when you get the query
that you like, copy the sql code into your app.
I don't think that's exactly what he was after.
Please read the question before spamming the list with advertising.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
