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
Slow Result Transfer Performance
Re: Slow Result Transfer Performance
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.
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.