Quote:
Originally Posted by GBL
Hello,
I understand there're quite a few people here who uses database for handicapping software or data mining.
I am on Windows 10 and have MS Office 2013 suite so MS Access would be my preferred choice of database. Both OS and MS Office are 64 bits.
So far I have been using MS Excel for my purposes, although it's not a proper database, but then until now I had limited scope as well.
So before switching to MS Access I wanted to have some feedback from the experienced users and know how they feel about it.
Let's suppose you plan to have 2-3 million races (maybe it's impractical but wanted to set the highest limit possible) stored in your database spanning several years, my main concerns are:
1. Database size
2. Performance
3. Data integrity
4. Database maintenance
5. Database rebuilt, in case of data corruption
6. Response time -- especially when running SQL queries.
Based on your experience, is MS Access a good overall choice? I would appreciate the opinions both for and against.
Thanks in advance.
|
OK....let me start off with that Access is stupid
You yourself is the driving force ..You tell it what to do.....!!!!!!
You knowing Solver and also regression analysis is immense...
Its your starting point to valuable and reliable data research...
Once you do know your direction , the queries will be super fast...
EX:
Say you have a 100 Factors ranked 1 thru 10 on each for every track surf dist...
Tell Access to find me top factors for AQU 6fur dirt claiming races...
Guess what ,Access looks at you and says WHAT???
Do this in Excel Solver and it will spit out something like First Fraction then Class then Pedigree then 2nd Fraction....down the line
Now you can use Access to plug in that info one at a time to develop the play
Input AQU 6fur dirt claiming then First Fraction ...it will give you the rois for ranks 1-10...say you see Rank 1 and 2 are significant , then you add that and then go to CLASS, there you se 1-4 will enhance the play...
and so on...but beware the more you add the less number of plays you get
But I'm sure you know that already....
Once you get the results that your satisfied with , create the query and your set for each race day...
Access is good but not the magic bullet people think...
So now you have to decide if taking the time to learn it is worth it ?
as You can do most of this in Excel as you've been doing...
Mike
