Shaun Seckman (Firaxis) <shaun.seck...@firaxis.com> wrote: > Say I have the following prepared statement "select > B.foo from A inner join B on A.bar = B.bar where A.foo = ?" used to > populate values from a reference table. If I intend on executing this > statement several times with different bound values, is it better for > me to generate a temporary table to remove the inner join or will > SQLite internally keep a temporary table for this statement?
I'm not sure what temporary table you are talking about. There's no reason for SQLite to generate a temporary table to execute this statement - let alone keep one around. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users