>>I have some vfp8 applications that are getting slow when adding users (uses VFP database on a WinServer).
>>
>>I wonder what is the best situation for a 10-20 users setup:
>
>10-20 users is not a whole lot of users. Are you using views? If so, are they in a shared DBC? Perhaps your issue is locking contention in the DBC. See this topic in the wiki...
>
>http://fox.wikis.com/wc.dll?Wiki~BigSystemPerformanceAndVisualFoxPro~VFP
>
>This issue comes into play with about 10 users, so I've heard. What I do is create a dedicated DBC for views and embed this dbc in the exe, so each user has his own dbc for views.

Good point. Actually we banned the views last week and replaced it by select - sql (updatable when needed). It has increase significately the speed because we fire them only when needed (ex.: when user click on the invoices tab of the client screen instead of in the after init event).
Maybe from there we will not have a speed problem before 50 or more users. From what I read here we can go to a significant number of users without any speed problem... we will see.
Thanks