Ashish Kulkarni wrote: > 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
Good idea; however, I'm going to implement the column index caching using a Dictionary, which will result in slightly more efficient operation. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users