[dotNetRDF-Develop] Issue SQL-146 has a new comment

[<tr...@do...>]

A new comment has been added to the following issue.

Title: 0.5.0 MS SQL backend poor performance
Project: Data.Sql (dotNetRDF.Data.Sql.dll)
Created By: Rob Vesse
Date: 2011-11-22 03:34 AM
Comment: 

 So this definitely appears to be a network related issue. On a local instance with 418 triples the query executes in 0.5s 


 With the same data on a Windows Server 2008 box located back in the UK accessed from my apartment in California the same query takes 1m 13s, I will try and debug further to see how many queries have to go over the network to serve this query. 


 Also I wonder whether this may be an issue related to streaming the data with a DbDataReader versus just dumping it into memory with a DbDataAdaptor, depending on the outcome of this I may add an operation mode whereby the provider will request query results all at once. If this will be the case then this will not be the default mode of operation because it reverses any attempts to reduce memory usage which was one of the key aims of the new backend.

 More information on this issue can be found at http://www.dotnetrdf.org/tracker/Issues/IssueDetail.aspx?id=146


      If you no longer wish to receive notifications, please visit http://www.dotnetrdf.org/tracker/UserProfile.aspx and change your notifications options.