heribert wrote: > "Not very much. But preparing a statement is very fast; don't try to be too > clever." > > What do you mean with "don't try to be too clever"? Is preparing for reuse > not really necessary?
In many cases, the difference will not be noticeable. I was warning against adding complexity to handle the caching of many prepared statements. > The select will be like "SELECT Value FROM RgbValues WHERE Object=? AND > Property=?". > Will it be better to prepare the sqlite3_stmt and reuse it? Yes; for a single statement, this is likely to be simpler, too. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
