Re: Problem LIMIT performance
i would try this query, though it will only work if you're using MySQL 4.1 or greater.
SELECT re.reaId, re.reaEntryId, re.reaName, re.reaDaturn, re.reaTijd, re.reaMemo, (SELECT us.usrUserID FROM tblUsers us WHERE re.tblReactie.realName=us.usrNickname GROUP BY re.reaEntryId) FROM tblReactie re, tblDagboekEntry da WHERE re.reaEntryId=da.dagEntryId AND da.dagPublic=1 ORDER BY re.reaId DESC LIMIT 50
and make sure that any field referenced after your WHERE clauses are indexed if any of them aren't your primary key.
Subject
Views
Written By
Posted
6675
May 05, 2005 05:07AM
Re: Problem LIMIT performance
2794
May 12, 2005 09:00AM
2358
May 15, 2005 10:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.