slow performance sql
Many nodes, many users on forum module
I'm new to the High Performance group and I'm interested to find out if people here have run a site with the following stats:
- 4,000 simultaneous visitors, up to 500 who are logged in at once
- approaching 2 million comments
- 200,000 forum posts
- 30,000 registered users
Slow queries - Problem with accessing Content management -> content
We have just installed the latest version of Drupal 5 on a new site and loaded it up with content, about 4.1 million nodes. These nodes are split between three types of content types, which amounts to around 2.6 mill, 1.5 mill and 70.000 nodes for each type.
Hitting the administrator menu : Content management -> content destroys performance beyond anything I've seen :)
This is the query which totally smother the performance, taken from the developer module:
