SCM

Forum: Npgsql: bytea handling performance improvements

Posted by: Francisco Figueiredo jr.
Date: 2005-12-19 21:39
Summary:Npgsql: bytea handling performance improvements
Project:Npgsql .Net Data Provider for Postgresql

Hi all,

Today I just commited Hubert patch (http://pgfoundry.org/tracker/index.php?func=detail&aid=1000458&group_id=1000140&atid=590) to send and receive bytea values as byte[] streams instead of translating them to bytea strings.

This gives a big improvement in memory usage. In fact, as Hubert says, it reduces in 5 times the memory usage of bytea handling.

I also commited a patch to better Npgsql network handling. We were abusing of Stream.Flush() calls which reduced a lot the gain obtained from BufferedStream usage.

Please, give it a try and let us know if has any problem.

Sponsors Ads

Latest News

Npgsql code repository changed to git

Francisco Figueiredo jr. - 2013-06-28 22:35 -

Npgsql 2.0.12 beta2 released!

Francisco Figueiredo jr. - 2011-09-29 02:30 -

Npgsql receives donation of an MSDN subscription!!

Francisco Figueiredo jr. - 2010-08-23 22:13 -

Entity Framework Sample posted

Francisco Figueiredo jr. - 2009-11-12 20:48 -

Npgsql 2.0.6 released!

Francisco Figueiredo jr. - 2009-07-21 14:35 -
Monitor Forum | Start New Thread Start New Thread
You have to use NpgsqlCommand.Prepare first [ reply ]
By: Francisco Figueiredo jr. on 2005-12-15 12:49
[forum:1000961]

In order to get benefits from performance improvements, you will have to call NpgsqlCommand.Prepare before using any code which uses bytea parameters. To send and to receive.

I forgot to say that on my original post :)

Powered By FusionForge