SPECIAL NOTICE
Malicious code was found on the site, which has been removed, but would have been able to access files and the database, revealing email addresses, posts, and encoded passwords (which would need to be decoded). However, there is no direct evidence that any such activity occurred. REGARDLESS, BE SURE TO CHANGE YOUR PASSWORDS. And as is good practice, remember to never use the same password on more than one site. While performing housekeeping, we also decided to upgrade the forums.
This is a site for discussing roleplaying games. Have fun doing so, but there is one major rule: do not discuss political issues that aren't directly and uniquely related to the subject of the thread and about gaming. While this site is dedicated to free speech, the following will not be tolerated: devolving a thread into unrelated political discussion, sockpuppeting (using multiple and/or bogus accounts), disrupting topics without contributing to them, and posting images that could get someone fired in the workplace (an external link is OK, but clearly mark it as Not Safe For Work, or NSFW). If you receive a warning, please take it seriously and either move on to another topic or steer the discussion back to its original RPG-related theme.

limit on subscribed threads?

Started by beeber, October 25, 2007, 05:49:23 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

beeber

October 25, 2007, 05:49:23 PM
as in, how many can we have?  i'm wondering if i should clean out some of the older ones.

James McMurray

#1
October 28, 2007, 09:21:33 PM
I'd be surprised if there was a limit. Most likely there's a table in the database called subscriptions that ties user ids with thread ids and has no built in limit. But if they're old threads you don't use any more, deleting them would shrink the table and speed queries using it.

brettmb2

#2
October 28, 2007, 09:36:07 PM
No idea. I'll look into it when I get some free time.
Brett Bernstein
Precis Intermedia

beeber

#3
October 28, 2007, 10:48:54 PM
cool, thanks.  i'm almost to 200 at this point, which feels a bit excessive.

brettmb2

#4
October 30, 2007, 09:52:44 AM
Upon some investigation, I don't believe that there is a limit. It would certainly reduce the site's database if older ones were cleared, but it would require many folks to do that, so it's a trivial matter. Don't worry about it.
Brett Bernstein
Precis Intermedia

beeber

#5
October 30, 2007, 10:06:36 AM
thanks for checking, brett.  'preciate it.

brettmb2

#7
October 30, 2007, 10:11:48 AM
Quote from: James McMurrayDamn I'm good. :)
I guess it helps to know what you're doing :)

No problem, beeber.
Brett Bernstein
Precis Intermedia

James McMurray

#8
October 30, 2007, 01:16:22 PM
I wouldn't say know. More like educated guessing coupled with no fear of being wrong. :)
Print
Go Up Pages1
User actions