Dlugo realizuje zapytanie.. Opcje

[suryx]

Nie wiem w jaki sposob ma ,zeby przyszpieszyc realizacja. I posiadam php fusion v7 , zrobie wlasny forum..

Moj SQL :

SELECT a.forum_id, a.thread_subject, b.post_datestamp, b.post_author FROM ".DB_POSTS." a
LEFT JOIN ".DB_POSTS." b ON b.thread_id = a.thread_id
LEFT JOIN ".DB_FORUMS." c ON c.forum_cat AND c.forum_id
WHERE c.forum_cat='13' AND c.forum_id=a.forum_id ORDER BY b.post_datestamp DESC, a.post_datestamp ASC LIMIT 1

+----------+---------------------------------------+----------------+-------------+
| forum_id | thread_subject | post_datestamp | post_author |
+----------+---------------------------------------+----------------+-------------+
| 10 | Jaka jest Wasza ulubiona cywilizacja? | 1233868283 | 2 |
+----------+---------------------------------------+----------------+-------------+
1 row in set (0.41 sec)

0.41sec = to tak dlugo , raczej w sumie z php dluzej niz to co widac.

thread_subject w kazdym kategorii(c.forum_cat) jest ostatnim postem , a b.post_datestamp = swiezy czas kiedy zrobil post i a.post_datestamp = kiedy zalozyl pierwszy post.