FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » fud_read table huge
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
fud_read table huge [message #25472] Thu, 09 June 2005 09:20 Go to previous message
sdefranc is currently offline  sdefranc   Australia
Messages: 28
Registered: May 2002
Location: Australia
Karma:
Junior Member

Hi all,

We're been running a pretty old version of FUD for a while now - 2.3.8. I've noticed lately the performance getting worse, so I thought I'd check out the database.

The major bottleneck seems to revolve around the fud_read table, which is now massive - around 519MB in size.

What is the purpose of this table? From what I can tell, it just records when a post was last read, or something like that? Is there any reason for it to be so big? What are the consequences of just blowing away that table Twisted Evil

Forum stats are as follows:

Our users have posted a total of 665976 messages inside 68347 topics.
We have 10743 registered user(s)


Thanks
Sam

[Updated on: Thu, 09 June 2005 09:20]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Mailing List- Using a Reply-able email sending account
Next Topic: finduser.tmpl
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 05 20:45:56 GMT 2024

Total time taken to generate the page: 0.04633 seconds