Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
'Do from' command
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00714970
Message ID:
00714986
Views:
29
Are you sure it's the DO FORM that is going slowly and not the SET FILTER ???

>Hi,
>
>This might be a very strange question. But any help will be greatly appreciated.
>
>In our application, the users carry out searches and the results are shown on the next screen.
>
>This is how the program flows:
>
>- User enters the Search Criteria an starts a search
>- The program searches one table ( the search screen is divided into sections, so that the user is querying only one table at a time) and retrieves matching records to a temporary table
>- Then we use set filter on the other tables to retreive the records that this user can see (based on their security level they can see only certain records. For example if a manager is logged on, the program issues a statement like 'Set filter to UserType = 'MGR')
>- Then it establishes the relationships between the tables
>- Executes the line 'Do Form SearchResults'
>- The form 'SearchResults' displays, the values from various tables in various grids.
>
>
>We noticed that for different users, the search speeds were different.
>And while stepping through the code, it was noticed that the querying & filtering was quick but, the line 'Do Form SearchResults' took longer to execute for different users.
>
>And from our tests it was clear that it was in no way dependant on the number of records returned for various users.
>
>What does FoxPro do when it executes the line 'Do Form SearchResults'?
>
>Though we noticed that it was this line that took differnt times for different users, could this really be the problem?
>
>Anu help will be greatly appreciated.
>
>Thank you.
>
>Ria
ICQ 10556 (ya), 254117
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform