F.A.Q.    Register    Login    Home Members    Search

Toymods » Toymods Membership & Feedback » has this site been slow for other ppl Show: Today's Posts  :: Show Polls  Email to friend

Author	Topic
Sam Forums Junkie Location: Sydney, Australia Registered: May 2002	Re: has this site been slow for other ppl Thu, 09 June 2005 21:36 Cool1 wrote on Tue, 10 May 2005 20:51 I find it fine except for when I hit the (mark all posts as read) and then it sits there dreaming for ages OK Cool1 hit the nail on the head with this one. It seems that the fud_read table stores a record for every thread for every user that says that thread has been read. In other words, we have 68000+ topics in the forum, so each user that clicks "mark all messages read" will have 68000+ records in that table! 10000 users multiplied by 68000+ posts equals database meltdown! I tested this myself by deleting all records for my user_id, and as expected, suddenly all my posts were unread. I then clicked the posts read link, and voila! - 68000+ extra records in the fud_read table for my user_id. Apparently later versions of the forum fix this - looks like we're overdue for an upgrade... Sam [Updated on: Thu, 09 June 2005 21:37] [Report message to a moderator]

	Subject	Poster	Date
	has this site been slow for other ppl	Mr DOHC	Tue, 10 May 2005 10:48
	Re: has this site been slow for other ppl	Cool1	Tue, 10 May 2005 10:51
	Re: has this site been slow for other ppl	Mr DOHC	Tue, 10 May 2005 10:59
	Re: has this site been slow for other ppl	Cool1	Tue, 10 May 2005 11:25
	Re: has this site been slow for other ppl	Sam	Thu, 09 June 2005 21:36
	Re: has this site been slow for other ppl	Corona RT142	Tue, 10 May 2005 11:04
	Re: has this site been slow for other ppl	Mr DOHC	Tue, 10 May 2005 11:38
	Re: has this site been slow for other ppl	Cool1	Tue, 10 May 2005 21:52
	Re: has this site been slow for other ppl	EvilJack	Wed, 11 May 2005 04:50
	Re: has this site been slow for other ppl	boofis	Thu, 12 May 2005 11:58
	Re: has this site been slow for other ppl	Ribfeast	Thu, 19 May 2005 11:01
	Re: has this site been slow for other ppl	nightdevil	Fri, 20 May 2005 10:30
	Re: has this site been slow for other ppl	Yian	Fri, 20 May 2005 22:55
	Re: has this site been slow for other ppl	ra_28	Sat, 21 May 2005 10:05
	Re: has this site been slow for other ppl	nightdevil	Sun, 22 May 2005 08:22
	Re: has this site been slow for other ppl	86DRFT	Mon, 23 May 2005 02:15
	Re: has this site been slow for other ppl	Conquest	Mon, 23 May 2005 14:30
	Re: has this site been slow for other ppl	EnFlaMEd	Mon, 30 May 2005 05:28
	Re: has this site been slow for other ppl	Cool1	Mon, 30 May 2005 12:22
	Re: has this site been slow for other ppl	Yian	Tue, 31 May 2005 07:41
	Re: has this site been slow for other ppl	piggy	Tue, 31 May 2005 07:57
	Re: has this site been slow for other ppl	Conquest	Tue, 31 May 2005 07:55
	Re: has this site been slow for other ppl	Yian	Tue, 31 May 2005 07:57
	Re: has this site been slow for other ppl	piggy	Tue, 31 May 2005 10:23
	Re: has this site been slow for other ppl	Sam	Thu, 09 June 2005 09:40
	Re: has this site been slow for other ppl	verbatim210	Fri, 24 June 2005 05:37
	Re: has this site been slow for other ppl	Joshstix	Thu, 30 June 2005 12:52
	Re: has this site been slow for other ppl	skellator	Tue, 28 June 2005 08:11
	Re: has this site been slow for other ppl	oldcorollas	Thu, 30 June 2005 09:47
	Re: has this site been slow for other ppl	peeack	Thu, 30 June 2005 13:50
	Re: has this site been slow for other ppl	oldcorollas	Fri, 01 July 2005 02:13
	Re: has this site been slow for other ppl	TurboRA40	Sun, 07 August 2005 11:37
	Re: has this site been slow for other ppl	86DRFT	Wed, 07 September 2005 10:04
	Re: has this site been slow for other ppl	oldcorollas	Wed, 07 September 2005 18:46
	Re: has this site been slow for other ppl	86DRFT	Fri, 16 September 2005 07:53

Previous Topic:	Raceflo complaint
Next Topic:	email notifications playing up

Powered by: FUDforum 2.3.8
Copyright ©2001-2003 Advanced Internet Designs Inc.