I want to extractmore than 600million record in mysql data base to qlikView (only one month data). I used my sql odbc connector. In loadingi used
“ limit” function to reduce the number of records. At a one time I can load 10million records(with 10 columns) within 20minit , without effect to server. If I increase thelimits of records the server will stack .
My questions are,
Is there any methods to do this ?
After loading , Qlik view can handle this kindof data volume?
In itself, QV is capable of handling more than a billion of records, but due to a timeout it might not be possible to load it all at once.
Since loading 10 million rows is no problem you might want to do it in these portions multiple times. Each time storing it in a QVD. This QVD might also save you loading all the historical data again the next time.