20.000 tables or 20.000 fields?
Posted on 2008-09-30
I have data in the following format which needs to be place in an access database.
I have about 20.000 or more signal values and multiple dates. What is better to do if I need to recall data later from the database:
1. create 1 table per signal? Like date,open,high,low,close,signal1,equity1,drawdown1
2. or, 1 table which will hold all data?