I'm sure i will experiencing same problem of that thread.
I just want to add my thought.
1)Microsoft Access is easy to use and a good DB for small processing.
But when you need to process millions of lines, ( for example, 6 millions lines for 20 years of daily bars on 1200 stocks, just daily...), application need to be well designed but overall database must be the most. Did you do performance tests before choosing Access with SQL Server or other real DB ? What are you thinking about your choice?
2)You said it takes 5 seconds to load 10 hours* 60 min * 15 days = 9000 lines. Did you try to optimize this?
Regards and congratulations for your work.
Comment