[Zachariah]

Originally Posted by Paul M

6,000 posts day ? are you sure, that's nearly 200,000 posts per month, the board only has 645,000 posts .....

I suggest they make sure that dateline has been correctly indexed in the post table, and run an explain.

At the end of they day its very poor performance by mysql slowing it down - even if I remove the index on my server, it only takes 1.5 seconds, and that is scanning 720,000 posts, not 645,000.

There are a lot of products on this VB install. Ill have to surf through the soup.
- I'll let you know what I find :tired:

Current Output:
They all show the same data list. (ex: userid's )

Last 24 Hours | Last 7 Days | Last 28 Days | Overall

user 1 | user 1 | user 1 | user 1
user 10 | user 10 | user 10 | user 10
user 100 | user 100 | user 100 | user 100
user 1000 | user 1000 | user 1000 | user 1000

Page generated in 46.68237 seconds with 9 queries