I have a continuous form based on a view from SQL Server 2008R2.
If i open the view it takes 10 seconds for the records to display.
If i open the form it takes 20 seconds for the records to display. You can see the Running Query in the bottom right, it runs for 10 seconds, then starts again for another 10 seconds.
It looks like it runs twice (and unfortunately takes twice as long).
Is this normal?
Any help would be greatly appreciated