AnsweredAssumed Answered

Optimization Retrieve Records

Question asked by Fagreement on Feb 17, 2012
Latest reply on Feb 26, 2012 by HOnzaKoudelka


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.

any idea?