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 ...
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hello josn0w

 

Can you tell us the hardware configuration for the computer using Power BI desktop because it sound like and memory limits.

 

And by the way, I quite agree with Greg_Deckler about the number of record and the database...

 

Sebastien

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 :(