1 2 Previous Next 15 Replies Latest reply on Jun 29, 2017 7:07 AM by gethappy@happypc.com

    delay in ExecuteSQL when scripted vs. using Data Viewer?

    gethappy@happypc.com

      Wondering if anyone else has seen this ... using Data Viewer to run an executeSQL query, the results come back in less than a second.  But if I copy/paste the same code into a script and run that script ... it takes about 3 minutes to complete.

       

      EXACT SAME executeSQL statement, querying the exact same table with the exact same credentials, exact same layout, exact same found set.  doing the two above back to back.  very strange ...

       

      am I missing something??

       

      The table we are querying is large ... roughly 1 million records, but as I mentioned ... the query is the same in both situations.

        1 2 Previous Next