Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Form loading too slow while using filter option in the t
Message
From
28/10/2004 06:49:19
 
 
To
28/10/2004 04:45:30
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00955178
Message ID:
00955200
Views:
22
Hi,
> Can anyone suggest a methold to solve the problem that the form loading is too slow as the initial table was set with filter option like only the selected company code being show out in the form? If there is no filter function, the speed for form loading is very fast.

The behaviour you describe is typical even if if this table has an rushmore-optimizable index but the form tries to set the focus on a grid. If you are working on a form / page with a grid bound to that table, experiment a little to verify. Try setting the focus to another control, or even better [for test purposes only] delete the grid from the form and compare the start times then.

Another (only rarely encountered) possibility is having different filters on the same tale opened again in the same datasession.

You should give more information about your form / tables / dataenvironment: there are too many posibilities we cannot know about.

HTH

thomas
Previous
Reply
Map
View

Click here to load this message in the networking platform