SQL in Portal Filter to slow
I am using this request:
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?