Walter Meester
HoogkarspelPays-Bas
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!
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement