Walter Meester
HoogkarspelNetherlands
General information
Category:
Forms & Form designer
Hi Sze Sze,
Are you using any comboboxes and/or listboxes bound to a datasource containing more than about a 1000 items ?
If so, this might well be the cause of the slow loading of the form. Try a different strategy (For example grids) to do the same.
Are you using views that download a lot of data before showing the form ? If so, you might want to start with an empty view (DAtaonload = .f.) and requery it when the user has made some selections (to narrow the numbers of records to be downloaded).
Are you using DELETED() index tags on your table. Try to remove them. They're notorious for slowing things down, especially in a network environment.
Maybe there is other code in your forms that cause the slowdown. Use SET COVERAGE to Log.txt before loading the form (in the development environment of course) to determine which commands do take a lot of time.
HTH,
Walter,
>for my Inovice Form, There are two pages.
>I put the invoiceheader, invoicedetail , company and some other tables on
>the data environment.
>
>From the very beginning. The forms runs fine.
>after 1 years, the invoiceheader got 3,500 records, and the invoicedetail
>gots 25,000. records, the company got over 1,200 records,
>
>as The forms run, it spend over 30 seconds to display the forms.
>
>I know that it is the problem that I load too much data into the data
>environment.
>However, if i didn't do that , (all the textbox is set the control source
>already during design time.).
>
>What solution can make the forms runs much faster.. ??
>Thanks a lot.
>From Agnes
Previous
Next
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