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