Forum Discussion
Data won´t load from Access Database
Hello,
I think there's an issue with you database design and optimization.
I've got a different configuration VM (64 bits, 4 Go RAM) and try to use it for direct querying a 6.000.000 rows tables from Sql Server.
I was facing that CefSharp.BrowserSubprocess.exe hang when I tried to access my table.
I optimize it with a ColumnStore Index and everything was quite fine.
I know you cannot use this king of index with Access, but I think you should try to optimize your tables with indexes and aggregate tables.
Let me know if it help you.
Sébastien
Anonymous
So just adding indices will solve it?
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
MS Access is alot better than a lot of people give it credit for but as the other guys have pointed out, its not designed for that many records, are you able to run any queries with Access itself?
If switching to one of the fee alternatives is not an option (Mysql, SQLserver express etc) I would look at exportng the data to a csv and importing from there.
As an aside, you can usually get around the lack of space issue in Access if you create a new table/column rather than try to update existing. In your case you could try creating a new empty table with auto-increment primary key (and other keys if appropriate) then use an append query to add your data. Using the compact database tool also helps if you have a lot of data.
