Walter Meester
HoogkarspelNetherlands
Hi John,
It all depends on what kind of transactions the users make. If mainly for DS (Decision support) in which the number of reads far exceeds the number of writes, there should not be too many problems with 100+ users (concurrent ?). However if the nature of the applications is OLTP (OnLine Transaction Processing) a lot of network contention could arrise and blocking other processes.
Anyways, you should carefully design your system. You should avoid holding filelocks, and keep the time of a lock limited to the time needed to write actions (thus not locking records to give users the time to edit the record).
Walter,
>A question came to me as to whether Foxpro degrades dramatically with 100+ active users. I do not know if SQL server or equivalent is used as an engine or just Vis Fox...
>Do any of you have any experience using Visual Foxpro with this many users? If so, is there a way to address potential performance degredation with 100+ users?
>
>Thanks, as always for your thoughtful responses!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only