Archive (Page 2 of 2)

Don't work

One of these request too expensive for my server (when there s ore than 15550 registered):
SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.status, u.registered, u.admin_note, p.id, p.poster, p.poster_id, p.poster_ip, p.poster_email, p.message, p.smilies, p.posted, p.edited, p.edited_by FROM t_posts AS p INNER JOIN t_users AS u ON u.id=p.poster_id
WHERE p.topic_id=2044 ORDER BY p.id LIMIT 100,20;

With a IN ?????????
SELECT t.id AS tid, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.forum_id FROM t_posts AS p INNER JOIN t_topics AS t ON p.topic_id=t.id WHERE t.id IN(2,3,4,5,6,7,8,11,12,13,14,15,16,18,20,25,29,35,40,51,53,55,56,60,90,95,101,108,110,125,132,149,158,165,176,179,181,233,255,304,325,329,338,402,412,436,468,600,613,618,629,691,697,742,758,769,820,834,875,883,903,918,925,1011,1018,1061,1096,1109,1131,1154,1176,1256,1302,1309,1312,1325,1344,1354,1366,1375,1392,1417,1433,1467,1468,1489,1495,1503,1517,1563,1571,1585,1620,1649,1655,1657,1674,1677,1694,1695,1711,1730,1731) GROUP BY t.id, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.forum_id ORDER BY t.last_post DESC LIMIT 0, 15;

Celeron 2 GHz
256 Mo RAM - 40 Go IDE
only for one website
PHP Version 4.3.0
Apache Version  Apache/1.3.26 
MySQL 3.23.53a

It's not one request which crash server. It's 50 users who do this request at the same time and crash server

I'm always in 3.23.53a
but i put an index to the table POSTS (field "topic_id") and it's better
server don't crash now

lebel: Your PunBB should have had an index on the topic_id column in the posts table already. I'm beginning to think there's something wrong with PunBB on MySQL 3. Especially considering this topic.