Forum Discussion

josn0w's avatar
josn0w
New Member
10 years ago

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 ...
josn0w's avatar
josn0w
New Member
10 years ago

Anonymous

Hardware:

Processor: i7-26420 @2.80 GHz

RAM: 8 GB

64Bit

 

Greg_Deckler

It was some demo data and yes there are 11.000.000 lines...

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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

 

  • josn0w's avatar
    josn0w
    New Member
    10 years ago

    Anonymous

    So just adding indices will solve it?

    • josn0w's avatar
      josn0w
      New Member
      10 years ago

      In Access adding an auto-increment for 11000000 lines fails, because there is not enough space :(

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        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