Form load slow (Max Records) 1

[SSapphire]

Hi,

I have a form in ADP which takes very long to load. This is because the Sql query takes a long time to run. I have put in Indexes for the query. So, I cannot improve performance that way. I was wondering if there is any way that I can load the form with the first record and then continue processing the query in the background. I would greatly appreciate any help.

I tried setting the form Max Records to 1. But it looks like it just gets the first record and the query is not continued.

Please help.

 

[cmmrfrds]

Show the sql for the query. Normally, the adp form will start showing records as they are returned.