MS Access as Handicapping Database
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.
|