Are you also convinced that this is a very long time for such a query? Or is it normal?
Andrew Kreps wrote:
On Sat, 18 Sep 2004 22:25:12 +0200, Dirk Schippers
<[EMAIL PROTECTED]> wrote:
with indexes: id = primary, putdatetime, userid, {put,front,topcategory,approvedby} and review.
If I want to know the 30 most recently added and approved items, I do the following simple query: SELECT id FROM story WHERE put=1 AND front=1 AND topcategory=1 ORDER BY putdatetime DESC LIMIT 0,30
I couldn't help but notice that your query isn't specifying that the records you want are approved. Does your query time improve if you add approvedby to the query?
--
Schippers Dirk Zaakvoerder Frixx-iT http://www.frixx-it.com ------------------------------------------------------------------------ Bezoek ook http://www.verhalensite.com voor uw literaire tekortkomingen.
