Slow performance when using different networks

1 posts, 0 answers
  1. Lorena
    Lorena avatar
    1 posts
    Member since:
    May 2016

    Posted 29 May Link to this post

    Hi all,

    I am having very slow performance with Telerik Data Access when the database is not in the same network that the client application, but when I do not use Telerik the query returns the records very quickly.

    The client application is a simple console application and the database is SQL Server 2014.

    SISTEMA_LOG is a table with an autoincremented primary key with 16700 records, and the following instruction takes 35 seconds. 


    I have tried a lot of things. For instance, using take(5) before to "warm up", using low level ADO instead

    contexto.ExecuteQuery(Of SISTEMA_LOG)("Select * from sistema_log"))

    but the time of the query was the same, about 35 seconds in both cases.

    But when I use the following snippet, the time is only 2 seconds...

    Dim command As New SqlCommand("Select * from sistema_log", connection)
    Dim reader As SqlDataReader = command.ExecuteReader()
        Dim dt As New DataTable
    End Try

    I have tried a lot of things to improve the time but always with the same result... 

    I really appreciate any help you can provide.
    Thanks in advance.


Back to Top