Hello,
I've attached a patch which caches the column names in SQLiteDataReader.
During profiling a scenario where more than 100-200 records are read and
columns are accessed by name and not by index -- well over 50% of the time
was spent in System.Data.SQLite.SQLite3.ColumnIndex(). The attached patch
caches the field names in the data reader (using the same semantics) which
speeds up retrieval of records by a large margin.
Thanks,
Ashish
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
