9 Replies Latest reply: Feb 6, 2015 4:07 AM by Abhijit Bansode RSS

    Loading Big Datasets

      Hi,

       

      I am facing a problem wherein the query returns about 200 million records from a DB server and I am trying to load this into a qvd. It takes about 6 hrs to load 13 mil records.

       

      The query is fast ans returns in under 20 mins. The bottle neck is in serving the data from DB into the QV.

       

      Are there any means of speeding this up?

       

      Thanks.