On Fri, 2007-07-06 at 07:18 -0700, Mike Johnston wrote: > I have to join three tables to retrieve bits of data from each. I'm wondering > if I use a view are there any performance issues vs. issuing the complete 3 > table join query in code. > > Also, is it quicker to have sqlite do joins on primary keys between tables > instead of doing three separate single table queries on the primary key in > code?
The short answers are probably not and no. But it depends on the exact view you're defining. If it's just a join, no GROUP BY or ORDER BY or aggregate functions, it should be fine. Dan. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------