Jan Slodicka wrote: > > I have couple of small perf tips. > > 1) SQLite3.GetValue(SqliteStatement stmt, int index, SQLiteType typ) > > Starts with this code: > if (IsNull(stmt, index)) return DBNull.Value; >
I've adjusted the method to take advantage of the known affinity, here: https://system.data.sqlite.org/index.html/info/49bc3a15ba > > In my opinion the call into native code (IsNull) is unnecessary in case > typ.Affinity is known - which happens always right now. > > 2) SqliteDataReader.GetOrdinal() > This does not appear to be entirely compatible, most notable due to not taking the keyInfo into account. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users