Hi Marcus,
Thanks very much for your response. I was beginning to doubt my sanity. I thought I was seeing a dramatic slowdown due only to multiple users, but nobody seems to believe it.
I found it very interesting that you say:
"...at the moment we have the performance lack the same process in the application pulls about 10-times as much data down the network!"
One of our working hypothesis is that FoxPro is smart about the number of separate workstations working against a file. So if you have one computer running the EXE, no problem. But if you add one other workstation, FoxPro knows that if there is an index on the table, it needs to be brought across the network again after any updates by other clients. So if you have a 10MB CDX on the base table, you might expect a considerable effect on performance. Perhaps it is the index information that accounts for all the extra data you see coming across the wire with a second user.
I haven't been able to find any specific information on this aspect of FoxPro and how it handles index information in a multi-user scenario. Have you run across any information about this subject?
Précédent
Suivant
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