Anytime I have a fex go against a particular master file who...

[robert fuschetto]

Anytime I have a fex go against a particular master file whose table has about 5M rowsit takes forever to open the GUI for editing. Now, we do have a half dozen or so filters that allow the user to whittle down data as desired and that seems to come into play. Example: If I have only one filter, the GUI opens right up for editingbut 6takes forever.

Anyway, is there a setting to limit how may rows it reads to make it open quicker.

[robert fuschetto]

You know what, its not when I open the GUI but rather when I run itit takes for ever to pop open the filtersNow on the HTML page I get around this by pointing the parameters to a table that has our business hierarchybut for the the fex all it can do it go against the table w/5M rowshope this makes sense. I know, run it from the HTML page butis there anything else I can do

[Debra Waybright]

Maybe you need to create a filter on the field the parameter is looking at

[Martin Yergeau]

You probably need indexes on the 5M rows table based on the most used filter fields

[SATHEESH B]

If you are using Dynamic filters you may need to change the lookup values and display text from the Master table than the transaction table.

[Sarah Buccellato]

Robert, did any of these suggested fixes work

[robert fuschetto]

I will close this. Satheeshs idea is what we usually do however we were trying to avoid this since Deisgner Studio does not have this functionality.