AnsweredAssumed Answered

SQL in Portal Filter to slow

Question asked by firebase on Sep 17, 2014
Latest reply on Sep 17, 2014 by firebase

Title

SQL in Portal Filter to slow

Post

I am using this request:

ExecuteSQL ("
SELECT tbl1.name
FROM tbl1, tbl2
WHERE tbl1.name = ?
AND tbl2.number = ?
FETCH FIRST 1 ROW ONLY
" ;"";""; tbl3::name; tbl4::number)

in the Portal row filter, but its just to slow for me. It was ok untill i added the 2. table in the FROm part, but after that it takes about 10 seconds to load every new page.

Is there any way to speed this up? Is there a way to do it in regular FM functions? If so would it be faster?

Outcomes