Self Join

[Smoker616]

I use the folowing for a self join in MySQL
SELECT * FROM post_table t1
INNER JOIN post_table t2 ON (t1.post=t2.post)
INNER JOIN post_table t3 ON (t2.post=t3.post)
WHERE t1.index BETWEEN 294 AND 1318
AND t2.index BETWEEN 2210 AND 3379
AND t3.index BETWEEN 30122 AND 30237

This runs very slow and my host doesnt support sub querys. Any ideas on how to make this more efficient

[r937]

indexes?

[Zenith]

First mistake is: SELECT *

You should never ever make an SQL clause that way. Even though you need all fields you'd name them.

If you have heavy join pick only columns you need, that'll make it a lot quicker.