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

hba’s picture

Version: 4.7.x-1.x-dev » 5.x-1.x-dev
Assigned: Unassigned » hba
Status: Active » Fixed

I just added these indexes to 5.x. Thanks.

Anonymous’s picture

Status: Fixed » Closed (fixed)