Typically I open a connection and a command instance and associate instantiated parameters with the command instances, then process in a loop simply changing parameter values.
I have a situation when I am needing to insert and select based on several criteria and that practice looks a bit ugly. What are the guidelines surrounding command instances, parameters and query text with the client in terms of best practice when performance is a consideration? Thanks, jlc _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users