[sqlite] Slow View Performance

[Matt]

I have Tables TabA, TabB and TabC

 

I have a view ViewBC that is a view 

SELECT fields FROM TabB INNER JOIN TabC

 

If I run 

            SELECT fields FROM TabA LEFT OUTER JOIN ViewBC

it is way slow (like ignoring all indexes)

If I run

            SELECT fields FROM TabA LEFT OUTER JOIN TabB INNER JOIN TabC

 it runs as I expect.

 

Is this a know issue? Is there a simple workaround?

Matt Froncek
QODBC Development Support / FLEXquarters.com LLC Consultant
QODBC Driver for QuickBooks - Unleash your data at  <http://www.qodbc.com/>
www.qodbc.com