RE: [sqlite] FW: Performance problem with complex where clause

Thanks for suggestion. Now I can say for certain that no index is used on Link table in query Select ne.* From Node AS n JOIN Entity AS ne ON n.LOCAL_ID = ne.LOCAL_ID JOIN Link AS l JOIN Entity AS le ON l.LOCAL_ID = le.LOCAL_ID Where l."Target.Id" =

RE: [sqlite] FW: Performance problem with complex where clause

:[EMAIL PROTECTED] Sent: Wednesday, May 02, 2007 6:58 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] FW: Performance problem with complex where clause Александр Прокофьев wrote: > I'm running a query against sqlite database and it runs very slow - about 5 > seconds(on larger database it c

[sqlite] FW: Performance problem with complex where clause

I'm running a query against sqlite database and it runs very slow - about 5 seconds(on larger database it can ran for a whole minute). Select [Node_Entity].* From [Node] AS [Node_Node] JOIN [Entity] AS [Node_Entity] ON [Node_Node].LOCAL_ID = [Node_Entity].LOCAL_ID , [Link] AS [Link_Link] JOIN