>>>>>>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
>>>
>>>Have to ask you again: do you have any Select-SQL statements, or List/Combo with SQL-query or cursor as rowsource, or maybe you have grids?
>>
>>Yes, I have grids on two pages of the form.
>>How to optimize it?
>>Ed
>
>What are grid recordsources? Do you set Column.ControlSource individually or use default?
Column.ControlSource are the same as Column.Text.ControlSource and were set
by default.