FUDforum: FUDforum 3.0+ » Question on FUDForum capacity....

Home » FUDforum Development » FUDforum 3.0+ » Question on FUDForum capacity....

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

Re: Thank you very much for the response.... [message #27343 is a reply to message #21548]

Mon, 05 September 2005 15:40

ctbk

Messages: 142
Registered: April 2002
Location: Milan, Italy

Karma:

Senior Member

Watchnut wrote on Fri, 03 December 2004 01:34

.....was hoping there was a real-world setup of FUD that was about an order of magnitude larger (that is, roughly 5 million posts housed across multiple forums). I'm trying to gauge whether re-indexing of the database on deleted and edits of posts is going to make the software unacceptably slow. Also trying to gauge the efficiency of the search engine on a setup of that magnitude.

Regards,

Michael

I'm bringing back this thread to ask a question. Anyone has any exprerience with very large forums managed by fud? We've got a forum containing 3.000.000+ messages, and it seems that recently we reached some kind of magic number, because database performance has suddenly become unbearably poor. The cause of all this is the indexing, of course: disabling search functionalities the forum gets blazing fast at once. fud2_index contains 54.000.000+ rows.

We are still using an old version (2.5.0) of the software and we are wondering if something adressing this specific issue has been done in the meanwhile to make an upgrade worth it. You can understand how traumatic could be an upgrade in a forum of such dimensions, and we cannot take any chance unless some drastic optimization hasn't been done. The forum, otherwise, runs perfectly, and this problem presented itself only in the last weeks: we suspect that after a while wait-times grow exponentially instead of linearly.

In your opinion, would be difficult to write a hack to delegate this specific indexing/searching task to another application (running on another machine, for example)?

thanx

~
~
:wq

Report message to a moderator

[Message index]

		Question on FUDForum capacity.... By: Watchnut on Thu, 02 December 2004 22:33
		Re: Question on FUDForum capacity.... By: Ilia on Thu, 02 December 2004 23:17
		Thank you very much for the response.... By: Watchnut on Fri, 03 December 2004 00:34
		Re: Thank you very much for the response.... By: Ilia on Fri, 03 December 2004 01:24
		Re: Thank you very much for the response.... By: ctbk on Mon, 05 September 2005 15:40
		Re: Thank you very much for the response.... By: Ilia on Tue, 06 September 2005 00:54

Previous Topic:	I have an error
Next Topic:	does a database schema of fudforum exist ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 03:34:12 GMT 2024

Total time taken to generate the page: 0.05912 seconds