Re: [sqlite] inner joins on prepared statements

Shaun Seckman (Firaxis)
<Shaun.Seckman@xxxxxxxxxxx> 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@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users