>>>>>>>>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.
>
>What are grid recordsources (answer it, please!)? Do you use any Dynamic properties?
No, I don`t use any dynamic properties