[FlyingDutchman]

Originally posted by neuron
guess it's becouse of database size or something...

I'll see if I can test a little to find out what it is.

Becouse that ONE query takes 12 seconds, if I take away that the rest goes in 0 sec's

// edit

It's the LEFT JOIN that does it, it's a major performance hit in mysql, I'll post more info if I can find a solution.

(adding indexes will probably speed it up to about 0sec per query )

//edit2

if you have a fairly new mysql server (connect to it and confirm that the query works) replace the LEFT JOIN with INNER JOIN, my results on a 1.4ghz tbird, big database:

INNER JOIN:
1 row in set (0.01 sec)
LEFT JOIN:
1 row in set (50.18 sec)

output is identical of course

Were you talking to me? I mean, i have no f*cking idea were you are talking about
My database should be ok, and the server has 2x 800 mhz PIII... the latest threads do show up, but the news and the poll just don't

I can't give you guys and URL, because it's in a private network...
I really need to get this hack to work