General information
Category:
Forms & Form designer
Mike,
I work with a program that was written in FP-DOS.
All queries and filters work fast and dependable from command window.
But inside the form with grids and queries it works very slow.
I`m going to rewrite this form and to use inside it cursors(created with Select-SQL)instead of filters. Hope, it`ll work for large tables.
Ed
>Ed,
>
>Be sure that you have indexes on any fields or expressions that could possibly have a bearing. You might try some basic tests from VFP command window to confirm that essentially equivalent operations (e.g. queries and browses) have the kind of performance you'd expect. Once you establish that the kinds of queries involved in your form are capable of performing adequately outside of the form, then you can return to working on the form. Isolating and resolving the problem in this way may be easier than going straight to the form.
>
>Mike
>
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only