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

    Reload time: SQL Load vs. CSV load



      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