I have been using UniDac for years, currently in Delphi XE10.3.2 with Firebird 3 and for one particular UniDac query I have come up with a (to me) strange problem. It is taking about 8 seconds to close.
The query is fairly simple (basically just a SELECT query) that connects to a Quantumgrid and the query returns about 10,000 records. The dataset and grid opens up and displays very quickly. No complaint there. 1 or 2 seconds at most.
But when I close the form and we close the query (qryGrid.close) it takes about 8 seconds. So of course the form just sits there and to the user that looks weird.
I could understand the qryGrid.Open being slow, but it is not. It is great. Why would the qryGrid.Close take so long? There are no OnBeforeClose or OnAfterClose events.
Any suggestions?