LOGIN
User Name
Password
Remember me


Register...Forgot password?
Main menu
Leagues
Gonzaga
Blue Max
Cartagena
Wooden Ships...
King Me!
VampiRing
Forum Message
Previous messagePost a replyNext message

City:Calera, OK US
Personal Data:Male, born: January 01 1960
HomePage or other cool site:http://www.smallbusinessconsultingexperts.com
Membership20years 115days ago.
Last Login10years 154days ago.
Last Move15years 170days ago.
sfatula is currently Offline!Send a mail to sfatula


Message header
Area/Game:General
Topic:Site-maintenance and Administration
Subject:Re: League Statistic Script and Games data retention policy
Posted by: sfatula - 10years 156days ago.
Message text
imdog wrote:
Hi all,

If you use the sites old enough, you will know that individual games data will be removed periodically.

Due to the MySQL constraint and the way system design, to avoid system crash, we need to clean up the game info DB every 12-18 month.

However, League score data will be keep though.

If you wish to check, here is the script.

http://youplay.it/play/tn_status.asp?GameID=2

GameID is the league ID if you could recall. Otherwise you need to check it 1 by 1

For e.g,

http://youplay.it/play/tn_status.asp?GameID=11

This is my very 1st Vampring League.

BTW, You could see the very 1st league completed 8 years ago already.

From a manual check, http://youplay.it/play/tn_status.asp?GameID=8512 , last data maintainence is almost some 15 months + ago, so you could see 31 months data is still there, but they will not last.

So that's why for serious gamer, you should try the league system.

Enjoy hacking fun

.


A problem even if you use the MERGE engine? Or partitions? I've got tens of millions of rows in MySQL.

Back to the messages list
Messages thread
Posting elapsed timePosted bySubject

10years 157days imdog [SYS] League Statistic Script and Games data retention policy
10years 156days sfatula Re: [SYS] League Statistic Script and Games data retention policy
 10years 154days imdog Re: [SYS] League Statistic Script and Games data retention policy
  10years 154days sfatula Re: [SYS] League Statistic Script and Games data retention policy
   10years 152days imdog Re: [SYS] League Statistic Script and Games data retention policy
Next thread
Posting elapsed timePosted bySubject

10years 149days Swanto [WS&IM][OT] extra league created
10years 149days derekticus Re: [WS&IM][OT] extra league created
 10years 149days Swanto Re: [WS&IM][OT] extra league created
  10years 148days derekticus Re: [WS&IM][OT] extra league created
Previous thread
Posting elapsed timePosted bySubject

10years 160days sfatula [WS&IM][OT] Derekticus, you're still here?
10years 160days dcr66 Re: [WS&IM][OT] Derekticus, you're still here?
10years 160days sfatula Re: [WS&IM][OT] Derekticus, you're still here?
 10years 159days imdog Re: [WS&IM][OT] Derekticus, you're still here?
  10years 158days sfatula Re: [WS&IM][OT] Derekticus, you're still here?
   10years 158days imdog Re: [WS&IM][OT] Derekticus, you're still here?
   10years 157days derekticus Re: [WS&IM][OT] Derekticus, you're still here?
    10years 156days sfatula Re: [WS&IM][OT] Derekticus, you're still here?
    10years 155days Electro Re: [WS&IM][OT] Derekticus, you're still here?
     10years 155days derekticus Re: [WS&IM][OT] Derekticus, you're still here?
     10years 155days sfatula Re: [WS&IM][OT] Derekticus, you're still here?
10years 157days derekticus Re: [WS&IM][OT] Derekticus, you're still here?
 10years 157days Longneck Re: [WS&IM][OT] Derekticus, you're still here?
 10years 156days sfatula Re: [WS&IM][OT] Derekticus, you're still here?
  10years 156days dcr66 Re: [WS&IM][OT] Derekticus, you're still here?
  10years 156days sfatula Re: [WS&IM][OT] Derekticus, you're still here?
   10years 156days dcr66 Re: [WS&IM][OT] Derekticus, you're still here?
  10years 155days Longneck Re: [WS&IM][OT] Derekticus, you're still here?
 10years 157days imdog Re: [WS&IM][OT] Derekticus, you're still here?
 10years 156days sfatula Re: [WS&IM][OT] Derekticus, you're still here?
Page generated in: 35.9375 milliseconds.