Devart Forums

I my application there is a complex Select-Statement which returns about 1000 records by using Delphi TDBGrid and TMSQuery. If the user doesn't scroll to the end of Grid, this data will occur an Error "ASYNC_NETWORK_IO" on the MSSQL Server.

The data is not editable. Is there any solution to solve and prevent this effect i.e. by Setting an IsolationLevel ?

Thanky for your Feedback.

I am using "FetchAll=False" in this Query.

To solve the issue, try the following:

1. A similar issue is described in the MSDN blog: http://blogs.msdn.com/b/joesack/archive ... ected=true . Try the suggestions from this article.

2. Try using Snapshot isolation level. For this, before establishing connection, set the TMSConnection.IsolationLevel property to ilSnapshot.

We already tried and checked the issues from the MSDN blog. I’ve just tried to use the snapshot isolation level too. This has no effect, the error still occurs.

Our current solution is to set the FetchAll property to true. But I hope for a solution in which not all data needs to transfer to the client.

Do you have any further ideas to solve this problem?

To solve the problem, try to use the SmartFetch mode. For this, set the TMSQuery.SmartFetch.Enabled property to True.