>>A form includes in dataenvironment two tables: members and payments.
>>Form runs pretty fast with small tables: members -2K records(2M) & payment-2K records(200K).
>>Form runs very slow when tables are large: members -35K records(30M) & payment-117K records(11M).
>>What can I change to increase form speed?
>>
>>Ed
>
>Table size itself shouldn't pose a problem. Probably, you run some queries, create view/cursors e.g. for Combo.Rowsource,etc. which slow down interface. If it's the case, try to optimize them.
Hi Edward!
Delay occures when I switch between pages (in pageframe) with different controlsource tables and at the start of the form.
Ed