Found Set Portals slow when increase data.

[Kishan_Canoo]

I need your help as I am in a blocking stage and I am struggling to get a solution without success.

Windows 7 - Filemaker Pro 11 Advanced 

I am working on a solution where you can select a Product name from a List of the same Layout and it displayed all details regarding that product.

The problem with the solution is when I increase the number of products from 100 units to 5000 units it became extremely slow.

I have attached the solution and I would be grateful if you could take some minutes of your time to solve the problem.

Product List.fp7

[Steve Martino]

I don't understand the need for the OnRecordLoad script trigger.  As soon as you remove that trigger from the layout it works fine.

Edited July 26, 2016 by Steve Martino

[Kishan_Canoo]

8 hours ago, Steve Martino said:

I don't understand the need for the OnRecordLoad script trigger.  As soon as you remove that trigger from the layout it works fine.

I removed the OnRecordLoad script trigger and it works well. Now problem solved. Thank you Steve. Much appreciated.