>>In real life, how big can we handle with a vfp6 application on native databases (on a NT 4) ? For a standard business application (accounting, invoicing, ordering, inventory, etc...), is there anybody running around 50 users ? What is the performance ? At this size, is it absolutely needed to go client-server ?
>
>I have over 100 users with multi-user DB, all native vfp. I'm not sure what the max simultaneous users has been, probably 30 or 40. No problems with performance, the system is large but quite fast, and we have some tables up to 500 MB.
>
>On the other hand, we have a PB/Sybase C/S system, about the same size app, that slows to a crawl with 10 users and 1 MB of data. They are really struggling to get it faster. So C/S won't necessarily solve all the problems by itself...it has a lot to do with application and DB design.
Hi Bruce,
PMFJI but what happens in the following situation:
VFP runtimes and the app/exe are installed localy on the users hardrive.
The .dbc is native VFP and resides on a a server.
All tables are accessed directly or through local views.
Wouldn't that be more of an OS issue as to how many times the file can be shared? I would think the VFP runtime wouldn't even know that anybody else is accessing the .dbc.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!