FUDforum: How To » Database size and "hang time"

Home » FUDforum » How To » Database size and "hang time"

Show: Today's Messages :: Polls :: Message Navigator

Database size and "hang time" [message #25527]

Sat, 11 June 2005 22:32

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma:

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)?

Report message to a moderator

[Message index]

		Database size and "hang time" By: BobB on Sat, 11 June 2005 22:32
		Re: Database size and "hang time" By: Ilia on Sun, 12 June 2005 17:19
		Re: Database size and "hang time" By: BobB on Sun, 12 June 2005 20:30
		Re: Database size and "hang time" By: Ilia on Mon, 13 June 2005 02:07
		Re: Database size and "hang time" By: BobB on Tue, 14 June 2005 00:27
		Re: Database size and "hang time" By: Ilia on Tue, 14 June 2005 01:31

Previous Topic:	Double posts and multiple topics
Next Topic:	How to do Simplified Chinese search?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 03:03:47 GMT 2024

Total time taken to generate the page: 0.04891 seconds