Hi,
ich werde hieraus einfach nicht schlau, aber anscheinend hängt deswegen regelmäßig unser Forum:
# Time: 050630 14:22:58
# User@Host: ICH[ICH] @ localhost []
# Query_time: 166 Lock_time: 5 Rows_sent: 14 Rows_examined: 1302
use ICH;
SELECT
post.posttime,
post.posttext,
post.userid,
post.postid,
post.postlasteditby,
post.postlastedittime,
post.postsmilies,
post.postcode,
post.postguestname,
post.postip,
user.username,
user.usersignature,
user.usertitle,
user.userposts,
user.userrating,
user.useravatar,
user.groupids,
user.userhomepage,
user.userisadmin
FROM
tb_post as post
LEFT JOIN
tb_user as user ON (post.userid=user.userid)
WHERE
post.threadid=9903
ORDER BY
post.posttime ASC
LIMIT
420, 15;
# User@Host: ICH[ICH] @ localhost []
# Query_time: 94 Lock_time: 1 Rows_sent: 15 Rows_examined: 47
use ICH;
SELECT
post.posttime,
post.posttext,
post.userid,
post.postid,
post.postlasteditby,
post.postlastedittime,
post.postsmilies,
post.postcode,
post.postguestname,
post.postip,
user.username,
user.usersignature,
user.usertitle,
user.userposts,
user.userrating,
user.useravatar,
user.groupids,
user.userhomepage,
user.userisadmin
FROM
tb_post as post
LEFT JOIN
tb_user as user ON (post.userid=user.userid)
WHERE
post.threadid=17256
ORDER BY
post.posttime ASC
LIMIT
0, 15;die Queries sind eigentlich normal benötigen allerdings manchmal massig Zeit!!