Database size and "hang time" [message #25527] |
Sat, 11 June 2005 22:32 |
BobB
Messages: 165 Registered: April 2005 Location: Tucson, AZ
Karma: 0
|
Senior Member |
|
|
Our database has about 200,000 messages stored. The vast majority are in one forum/category. When one posts a message or reply to that forum/category, the forum "hangs" for quite some time before the message is posted. That is, it takes a very long time for the page displayed to change, even though, when it does, it says it took only .03 seconds to generate the page. This "hang time" also results from admin actions, such as deleting messages and topics, and merging topics. There is no "hang time" for any actions in any of the other forums/categories.
How large a database is in use in other FUD forums? Could the database size be the reason for the "hang time"? Would it help if the database was split, making the main database much smaller (and putting the older messages into a separate database outside of FUD)?
|
|
|
Re: Database size and "hang time" [message #25537 is a reply to message #25527] |
Sun, 12 June 2005 17:19 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
We've got a forum running on this machine with over 700,000 messages are not experiencing any such problems.
One solution you may want to try is to try to avoid having a single forum containing the vast majority of messages in a bulletin board. Often when making a post, forum needs to rebuild the topic 'view', which may explain a slight delay if you have tens of thousands of topics.
Another solution is to increase the MySQL buffer sizes so it does not need to use temporary files.
FUDforum Core Developer
|
|
|
|
|
|
|