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.
That kind of difference can happen if your session has an open (uncomitted) record in the table you target with SQL. In that case, FMS will send you all the data first for the whole table so that the client can do the SQL query instead of the server doing it.