AnsweredAssumed Answered

Why is SQL slow at first run

Question asked by tomasd on Sep 9, 2013
Latest reply on Feb 4, 2016 by User29172

I have multifile solution and want to use some sql instead of relations. I have noticed that my sql is very slow at first run. Is it default behaviour of Filemaker's SQL?

The table on which I am executing SQL, has 160k records and I am using left joins. Second run, even with different parameters is quick. I suspect some caching of data...

 

"SELECT Issues.ID FROM Issues LEFT JOIN Participants ON Issues.ID="Record ID" LEFT JOIN "Project list" ON Issues.ID="ID Bug" WHERE ..."

Outcomes