Two DBGrid in the first sample occurs 1 time through Select. In the second DBGrid, sampling occurs when the cursor changes position in the first DBGrid, also Select.

SELECT*from Image_object_date Where (id_object=:id_object) ORDER BY id_imag DESC

Sampling is done through IBDataSet, Firebird 2.0 database.

When turning over in the first DBGrid there are PPC which brakes, and in the second there are no brakes at all. But if you turn off the sample in the second DBGrid, the first one stops to slow down.

Sampling time in the second DBGrid does not exceed 350ms.

Please tell me how to get around this problem.

    1 answer 1

    1) Brought query execution to a separate thread.
    2) Put a delay in the stream itself.
    3) And introduced the condition under which the query is executed
    The result is all the brakes are gone, but because of the delay there is a slight feeling that the application is tupit. But only I noticed it, users did not see it until I myself pointed it out to them.