5 Replies Latest reply: Jul 5, 2012 6:31 AM by Johannes Sunden RSS

    Reload time: SQL Load vs. CSV load

      Hi,

       

      I'm investigating a new way to load data into our Qlik templates.

       

      At the moment, we do everything via a LOAD SQL but I was investigating a method to get it done faster.

       

      This is what I have in mind:

       

      • Prod server: Run the query on the local server and export the table as CSV
      • Zip the CSV file
      • From Qlikview server: sftp get the file
      • Qlikview server: unzip the file
      • Load from CSV file

       

      Did anybody ever tested such a method? Would loading data from a CSV be faster?

       

      Any comment/suggestion welcome