I had recently investigated a performance issue in the contract window of FSM 6 UPD11.
This occurs when there are more than 1000 records in the lines tab.
When we navigate to the contract window and select the lines tab it took more than 1 minute to load the relevant data. If we navigate to another tab and comes back again to the lines tab it will load within 4-5 seconds.
I had executed the relevant hierarchy SQL in XML poster and it provide the result within 4-5 s.
Page size is set to 25, still no luck.
Please share your ideas on why it might slow on the first instance, and only when navigating for the first time to lines tab.