AnsweredAssumed Answered

delay in ExecuteSQL when scripted vs. using Data Viewer?

Question asked by gethappy@happypc.com on Jun 28, 2017
Latest reply on Jun 29, 2017 by 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.

Outcomes