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

Reply via email to