Slow Result Transfer Performance

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
GarethSaul
Posts: 2
Joined: Mon 28 May 2012 08:39

Slow Result Transfer Performance

Post by GarethSaul » Mon 28 May 2012 09:22

Hi

I'm evaluating using LinqConnect and dotConnect for PostgreSQL (5.8) in a project. I'm having some trouble loading a large result set from the database - the query is fast, but the row transfer is very slow.

Specifically, I'm using PgSqlConnection with Pooling enabled, Unicode on default (disabled?), connecting to a Postgre instance on localhost (Postgre 9.1.3 x64 on Windows Server 2008 R2 SP 1 x64). When transferring records, I'm seeing speeds of approximately 650Mbps. Profiling on the server with iperf demonstrates theoretical bandwidth of approximately 7Gbps. CPU usage is low.

I can't find anything I can tune or tweak to improve performance here. What can you guys suggest?

Regards
Gareth

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Slow Result Transfer Performance

Post by MariiaI » Mon 28 May 2012 14:49

In the previous versions slow loading of the result sets might be related to data materialization. In the latest version of dotConnect for PostgreSQL materialization performance was improved. Thus, you could try to upgrade your dotConnect for PostgreSQL to the latest 6.0.6 version.

Please notify us about the results and ,if possible, please send us the model you are working with and the DDL scripts, so that we could investigate this question in more details.

Post Reply