Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Maximum number of concurrent users with a VFP back-end
Message
From
01/03/2000 16:34:18
 
 
To
01/03/2000 16:09:48
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00339965
Message ID:
00340148
Views:
20
>We have close to 200. Sometimes rebuilding the index files will cause dramatic improvement. How your application is structure will make a difference, ie. are you using views? Are your queries/views fully Rushmore optimized? SEEKS? Mostly new records? Mostly edits? Your network infrastructure can make a difference too.

I think a good tip too is don't overdo it on indexes. I have seen some aps with 20 tags of more on some of the files... This actually causes more network traffic espessially with rushmore turnd on. Generally two indexs, a PK and a Candidate Key should be adequate. Other than that, use more order by and client side indexes.

BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform