Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Thoroughbred Horse Racing Discussion > General Racing Discussion


Reply
 
Thread Tools Rate Thread
Old 01-12-2017, 12:56 PM   #1
Sparky13
Registered User
 
Join Date: Jul 2009
Posts: 182
Question How long do you keep races in a Database?

I have a database with about 9,000 race results of information. I have races back to 2011. I can do all the filters I want to search the database. But, when is the information too old or does it not become too old? Thanks!!!

Last edited by Sparky13; 01-12-2017 at 12:58 PM.
Sparky13 is offline   Reply With Quote Reply
Old 01-12-2017, 01:01 PM   #2
TravisVOX
Track Announcer
 
Join Date: Jan 2004
Posts: 675
Never get rid of data! It's so cheap to store too.
TravisVOX is offline   Reply With Quote Reply
Old 01-12-2017, 01:08 PM   #3
ReplayRandall
Buckle Up
 
ReplayRandall's Avatar
 
Join Date: Apr 2014
Posts: 10,614
Quote:
Originally Posted by Sparky13
I have a database with about 9,000 race results of information. I have races back to 2011. I can do all the filters I want to search the database. But, when is the information too old or does it not become too old? Thanks!!!
IMO, data is only meaningful for the last 3 years, at least that's what I found to be my own truth....
ReplayRandall is offline   Reply With Quote Reply
Old 01-12-2017, 01:34 PM   #4
DeltaLover
Registered user
 
DeltaLover's Avatar
 
Join Date: Oct 2008
Location: FALIRIKON DELTA
Posts: 4,439
I cannot see a good reason of getting rid historical data instead I can think of many way to use it. By the way you historical db of 9K races is very small by today's standards, after you reach 1M you might consider archiving a part of it if this is something that will speed-up some of your calculations (like track variant or speed figure estimates)..
__________________
whereof one cannot speak thereof one must be silent
Ludwig Wittgenstein
DeltaLover is offline   Reply With Quote Reply
Old 01-12-2017, 03:03 PM   #5
classhandicapper
Registered User
 
classhandicapper's Avatar
 
Join Date: Mar 2005
Location: Queens, NY
Posts: 20,664
My data goes back to the end of 2014 and I plan on accumulating it for as long as I can on at last some race types and tracks. I did a split and link recently because I maxed it out. So now it's 2 databases that are linked together.
__________________
"Unlearning is the highest form of learning"

Last edited by classhandicapper; 01-12-2017 at 03:04 PM.
classhandicapper is offline   Reply With Quote Reply
Old 01-12-2017, 03:12 PM   #6
Tom
The Voice of Reason!
 
Tom's Avatar
 
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 113,006
I've got NYRA data back to 2000.

The thing you need to watch out for is a major change to something
Like at SA, the new grass surface.....I won't use the old grass data for much.
__________________
Who does the Racing Form Detective like in this one?
Tom is offline   Reply With Quote Reply
Reply





Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
» Current Polls
Wh deserves to be the favorite? (last 4 figures)
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 02:12 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.