in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Inefficient caching of sqlite3_column_decltype results

Last post 11-27-2009 3:07 AM by navaraf. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 11-27-2009 3:07 AM

    Inefficient caching of sqlite3_column_decltype results

    The provider stores results of sqlite3_column_decltype in SQLiteDataReader in the _fieldTypeArray variable. These values could be cached per-command instead of per-reader, which would greatly help in our use case.

    We have a prepared command which loads single row based on its rowId. With the current behavior sqlite3_column_decltype is called per each column for each row we load. Ideally it should be called for each column only once, when the command is prepared.

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