Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Multi-user Performance issues
Hi -
We have an app. that generaly manages large data file sets. The app. is a mulit-user app. We have found when the data files get quite large (250K records + in each file set) and as more users log into the system the app. pefermance slows down dramatically. Can someone please help point us in the right direction.
We have :
Set multilocks on
Sys(3050,1,10000000)
Sys(3050,2,6000000)
Set REPROCESS TO AUTOMATIC
Set DELETE ON
Set OPTIMIZE ON
Set RESOURCE OFF
We have also added to the config.fpw
tmpfiles=c:\work
editwork=c:\work
sortwork=c:\work
progwork=c:\work
set refresh to 0,20
BITMAP=OFF
PLease can someone assist us.
Thanks in advance.
Larry
instructed users if their workstation OS config.sys has FILES to increase to 255 (FILES=255) and if they have BUFFERS to increase to 40 (BUFFERS=40)
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