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:
00715060
Views:
34
Ria,

My general observation is that grid and filters don't like each other. If you use filters, and your filter would produce a small subset of records, and you show these records in a grid, no wonder, it would be slow.

As a test, try to remove grid from the form and see, if there is difference in speed. Also, do you use go top (or locate) after SET FILTER command? You have to move record pointer...

><
>When you say 'logging in as' do you mean logging into the 'app' as a specific user, logging into the 'domain' as a different user, or a specific server, workgroup, or what specifically? Is it a W2k domain, Novell, Window NT, Windows 98 workstation and Windows 98 peer server, etc?
>>
>
>- Yes, I mean logging into my application using different usernames & pwds
>- Test is on a WIN2K, Novell
>
><
>IN other words, what specific workstation, server, and network are you testing on? According to your statement below, you used the SAME workstation for testing and the data resides in the same location regardless of user (right?), so the only difference was the username and any account differences, correct?
>>
>
>- The data is in central location and not on the individual PCs
>
><
>Also, if it is filtered by mgr versus employee etc, the wouldn't manager accounts pull more records?
>>
>
>- Yes the MGR sees more records and yet it is slower for the employee than the MGR.
>
>>In production this might vary. But we were doing the tests on the same machine, logging on as different users each time.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform