my newly installed VPS website is much slower than orginal shared plan, I found out the difference is caused by one line of mysql query:
The vps and shared plan have exactly same set of data/script, newly installed VPS has no user on it, shared plan has some user.
The sql query takes time:
Shared Plan: 0.14 to 0.2 seconds
VPS ( no user at all): 1.8 Seconds
this is the line sql:
SELECT DISTINCT t.topic_last_post_time, t.topic_id FROM phpbb_posts p, phpbb_topics t WHERE p.post_time > 316626304 AND t.topic_moved_id = 0 AND p.topic_id = t.topic_id AND (p.post_approved = 1 OR p.forum_id NOT IN (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 25, 27, 28, 30, 31, 32, 33, 34)) AND p.forum_id <> 12 ORDER BY t.topic_last_post_time DESC
I have tried tuning the my.cnf in different ways, no much difference.
