Forum Discussion
Data won´t load from Access Database
When trying to load data (11 Million Lines) from an access database the process "CefSharp.BrowserSubprocess.exe" stays for more than 30 minutes by 25% CPU-Load. Afterwards the data didn´t even load ...
In Access adding an auto-increment for 11000000 lines fails, because there is not enough space :(
Adding indexes for aggregation should improve performance, but you could have another trouble.
Dou you have field with Money datatype? If yes, I think this could be problem. I was facing the same behavior with a small table (600.000 rows) having fields with Money Datatype.
When I tried to use them in a chart, the cefSharp.... hang !!!
So I change their datatype from Money to Numeric(13,2) or Numeric (13,4), and no more performance issue !
Good Luck !
Sebastien