TMSQuery.Active := False is slow

djb · Post by **djb** » Fri 13 Jun 2008 02:48

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

Antaeus · Post by **Antaeus** » Thu 19 Jun 2008 06:40

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.