Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Dealing with huge database

Hi,

I'm dealing with a 2tb database and have tried few times to load it but end up unsuccess. What can i do with it?

Anonymous
8 years ago
Anonymous,

Do you need all the columns of your database? I would recommend you specify required columns using SQL statement like "select col1,col2 from mydata.link_bi_betslips limit 5", and enter timeout value.

Regards,
Lydia

7 Replies

Greg_Deckler
Community Champion
8 years ago
I would recommend a Direct Query (Live) connection to that large of a database.
- Anonymous
  Not applicable
  8 years ago
  Greg_Deckler, my database is in MySQL. I can't find the option for me to perform Direct Query. Below is my view:
  - Anonymous
    Not applicable
    8 years ago
    Anonymous,
    
    There is no DirectQuery option for MySQL, in your scenario, I would recommend you write specific SQL statement to import required columns and rows.
    
    Regards,
    Lydia