Hi,
we are designing new database.
For us it would be easiest to use MS Access as dbsoftware. Otherwise it is MySQL. Those are our options.
We calculated that 5 tables will each reach 2 million records within two years.
But the records are very simple and short:
Col1 Col2 Col3 Col4 Col5
(text) (date) (int) (int) (int)
I know from experience that Access cannot decently handle >1 million long records.
But maybe if its only short records, it does perform well regardless of number of records ?
Please your advice. Access means less work and learning for us, but if performance so requires then we go MySQL.
Thanks!