in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows

Improve blob performance

Last post 10-24-2007 12:42 PM by Robert Simpson. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 10-24-2007 8:17 AM

    Improve blob performance

    Hi,

    ADO.NET only allow byte array for blob management.

    It's very ineffective, if blob source or destination is a file. You convert data from unmanaged to managed, and then back from managed to unmanaged.

    Why not extend the reader with GetBlob(int column, string fileName) and dbParameter with a new dbType "blobFile" and value = source file name.

    With this mecanism blob would only exist in the unmanaged world and it would process very fast.

    My two cents.

     

    Remi

  • 10-24-2007 12:42 PM In reply to

    Re: Improve blob performance

    Because that would be incompatible with the rest of ADO.NET ... We're aiming for 100% compatibility with ADO.NET.

    Robert

     

Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems