Devart Forums

I want to optimize uploading/downloading a large binary files with WCF client (Silverlight) and PgSQL. Except loading/saving a file entirely that will decrease server's memory performance, I want to do the same chunk by chunk. This is most important in SaaS scenarios.
Can you provide a small code example with best practice how can I do that?
Thank you!

An example of storing binary data in and retrieving them from a database is available at http://www.devart.com/dotconnect/postgr ... lBlob.html.

Thanks for the example, but is uses non-chunked method for storing/retrieving blobs. Is there an example with "chunking" blobs into parts?

There is a possibility for storing/retrieving blob to/from PostgreSQL server only entirely (as a whole). But you can read/write blob from/to memory in parts using the Read()/Write() methods of the PgSqlBlob class.