Devart Forums

I have a query where I’m selecting 2000 records. The query runs fine, and a delay can be expected, but when I close it by setting TMSQuery.Active := False, there is a noticeable (~4 second) delay.

Is there any option I should be aware of that would cause a delay like this when closing the query?

I’m running version 4.50.0.34 for Delphi 2007 Win32 VCL Edition.

Thanks,
Doug

I could not reproduce the problem.
Please send us a complete small sample at sdac*crlab*com to demonstrate it, including script to create and fill table(s). Also specify the exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.