Stephen,
There are a few ways to help control this, but depends on your circumstances on some of the tables in use.
In Tools/Options, the Remote Data page has a property for max records to fetch at a time. -1 = all records in the query... you can change this for global response to your applications.
If you are working with views, you might want to look into CURSORSETPROP() to update the FETCHSIZE to a specified number. Then when a view is being executed, it will only retrieve the defined limit first and continue. Then as needed, you can follow-up by getting the rest of the data with SQLMoreResults() based on your SQL connection handle.
Hope this helps guide you in the direction you needed.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only