Hi, I recently switched from phpbb to drupal. (http://drupal.org/node/44368)
Here is my configuration
- web server: Dual Xeon 3.0Ghz (32bit), 2G RAM, SATA HDD
- db server: same as web server (physically different server)
- software: apache 1.3.34, php 5.1.2, mysql 5.0.18
- total number of nodes: 70,000+
- total number of comments: 330,000+
- total number of users: 25,000+
- Usually there are 150+ anonymous users and 50+ registered users (by checking Who's online block)
- Modules: most core modules (4.7) except archive, book, drupal, legacy, ping with contributed modules (adsense, codefilter, favorite_nodes, google_analytics, logintobaggan, nmoderation, subscription, taxomony_access, urlfilter, votingapi, comment_upload, tagadelic)The problem was... the site was too slow at first. Especially, the 'view recent' was terribly slow. It took almost 10 seconds to display and showing node/posting comment also took more than 5 seconds.
So we modified the mysql database and tracker.module like....
For the whole text, please visit http://drupal.org/node/65269