Suggestion - Thread - Urban Exploration Resource


	UER Store
	order your copy of Access All Areas today!


	Activity
	791 online Server Time: 2024-04-19 04:25:52


	Visit
	Infiltration Access All Areas AvBrand

UER Forum > Private Boards Index > UER Database Talk > Suggestion (Viewed 2088 times)

Avatar-X Alpha Husky Location: West Coast Gender: Male Total Likes: 765 likes yay! \| \| \|	Suggestion < on 12/10/2010 7:59 PM > \| Reply with Quote

	I just came up with an idea to bring back Advanced Readstates in the Forum for everyone... Right now, I do an archiving run every now and again, which archives any threads older than 3 months. These are actually moved to different tables and the readstates are deleted. This helps speed up the site immensely. So here's what I'm thinking: Bring back "advanced" readstates in the forum only, for all those who want them (for free), with one change: The readstates only work for threads that have had a post in the last 30 days. That keeps UER from digging through thousands of older threads, while still allowing you to have the same level of readstates functionality for "current" threads, including instantly knowing how far you read. I could even have it delete readstates from the DB older than a month for a person who isn't a premium member. Premium members would get to keep the full readstates and also get full readstates in the location database. I think this could really work. -av
	huskies - such fluff.

AnAppleSnail Location: Charlotte, NC Gender: Male Total Likes: 49 likes ALL the flashlights! \| \| \| \|	Re: Suggestion < Reply # 1 on 12/10/2010 8:06 PM > \| Reply with Quote

	I'm a fan of this. Easy way out, eh?
	Achievement Unlocked

Emperor Wang

Location: On an island, in a river
Total Likes: 1029 likes

Fetish? What fetish?

Re: Suggestion
< Reply # 2 on 12/10/2010 11:35 PM >
| Reply with Quote

Sounds promising, but let's not rush into anything too quickly.

What are the criteria you're using for determining when to send a forum thread off to the archives? Are the criteria the same for all of the forums on the main page? Obviously the Encyclopedia and the Journals are special cases - are there any others?

I ask because I noticed some strange things while browsing the forums trying to get an idea of how much time the posts in each active forum cover.

The second column is the most recent post date (taken from the main page). The dates in the third column are taken from the last post of the last thread (or last few threads) in each of the active forums.


UE Main                Dec 10 2010  ->  Feb  1 2004
UE Photography         Dec 10 2010  ->  Sep  4 2010 + 1 thread  from 2005
UE Photo Critiques     Dec 10 2010  ->  Sep  4 2010
Rookie Forum           Dec 10 2010  ->  Sep  7 2010 + 3 threads from 2008-6
UE Website Updates     Dec  6 2010  ->  Oct 15 2010
UE Tutorials...        Dec  9 2010  ->  Sep  9 2010 + 1 thread  from 2006
 
World                  Dec  9 2010  ->  Sep  5 2010
Canada: Ontario        Dec 10 2010  ->  Sep  4 2010 + 6 threads from 2005-4
Canada: Quebec         Dec 10 2010  ->  Sep  4 2010 + 1 thread  from 2006
Canada: Alberta / BC   Dec  9 2010  ->  Sep  5 2010
Canada: Other          Dec 10 2010  ->  Sep  5 2010 + 1 thread  from 2008
US: Pacific Northwest  Dec  8 2010  ->  Sep  4 2010
US: Pacific Southwest  Dec 10 2010  ->  Sep  4 2010 + 4 threads from 2010-8
US: Great Plains       Dec 10 2010  ->  Sep 13 2010
US: Four Corners       Dec 10 2010  ->  Sep  6 2010
US: South              Dec 10 2010  ->  Sep  7 2010 + 2 threads from 2007
US: Great Lakes        Dec 10 2010  ->  Sep  6 2010 + 1 thread  from 2006
US: Southeast          Dec 10 2010  ->  Sep  4 2010
US: Mid-Atlantic       Dec 10 2010  ->  Sep  4 2010
US: Northeast          Dec 10 2010  ->  Sep  5 2010 + 5 threads from 2010-8
 
Forum Announcements    Dec 10 2010  ->  Aug  3 2004
Contact a Moderator    Dec  9 2010  ->  Sep  5 2010
Other                  Dec 10 2010  ->  Sep  4 2010 + 7 threads from 2008-4

I see now that something special's going on with UE Main and Forum Announcements too, but you can see what I'm getting at, right? There seems to be a glitch preventing the odd thread from sliding off to the archive on schedule. Is there any chance that the same glitch is causing extraneous amounts of outdated read-state data to pile up and slow down the forums as a whole?

It's great to be alive!

EatsTooMuchJam Location: Minneapolis, MN Gender: Male Total Likes: 24 likes Squirty "Stickybuns" von Cherrypants \| \| \| \| \| \|	Re: Suggestion < Reply # 3 on 12/12/2010 4:46 AM > \| Reply with Quote

	I'm a big fan of this idea.
	"The large print giveth and the small print taketh away." -Tom Waits

Avatar-X Alpha Husky Location: West Coast Gender: Male Total Likes: 765 likes yay! \| \| \|	Re: Suggestion < Reply # 4 on 12/12/2010 2:33 PM > \| Reply with Quote

	Yeah there's something funny with the old threads, I need to see what is going on there. -av
	huskies - such fluff.

UER Forum > Private Boards Index > UER Database Talk > Suggestion (Viewed 2088 times)

Add a poll to this thread

This thread is in a public category, and can't be made private.

All content and images copyright © 2002-2024 UER.CA and respective creators. Graphical Design by Crossfire.
To contact webmaster, or click to email with problems or other questions about this site: UER CONTACT
View Terms of Service | View Privacy Policy | Server colocation provided by Beanfield
This page was generated for you in 78 milliseconds. Since June 23, 2002, a total of 738466321 pages have been generated.