>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.
Edward Pikman
Independent Consultant