6 Replies Latest reply: Dec 15, 2011 5:26 PM by Alex Peasley RSS

    Troubleshooting qvw script

      So it takes 8 minutes for my script to year two variables. There 34 million rows in my qvd file. Should it take that long to create the variables? Is there a better way to do this?

       

      temP:
      Load
      num(min(TransactionDate)) AS MinDate,
      num(max(TransactionDate)) as MaxDate
      Resident Transactions

      Thanks, Alex