Optimization Retrieve Records
I have a FM application with SQL as database. in the main page of my application I have a portal where i displayed the total records of a table. the issue is that I have more than 9000 records, so when i open the application i have to wait around 3 minutes to have the portal displayed all the records.
How can I optimized this process?
is there any workaround to retrieve records "on demand" ? I explain, on open FM will bring only the 100 firdt records, and then like "Next page" FM will bring the next 100 pages.