Closed (fixed)
Project:
Guestbook
Version:
5.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
6 Jul 2006 at 11:01 UTC
Updated:
13 Mar 2007 at 21:01 UTC
I saw that you are using author and commentauthor columns in joins as well as created column for sorts.
I think it is better to add three more indexes for GUESTBOOK table:
KEY author (author),
KEY commentauthor (commentauthor),
KEY created (created)
This helped me to increase query speed for large guestbooks.
Thank you.
Comments
Comment #1
hba commentedI just added these indexes to 5.x. Thanks.
Comment #2
(not verified) commented