My application in Multiuser it is very slow, the slowness hapens in all application, in open and close forms, in data acess (seeks)and the display of information in the screen.
I`m using classes, the controls included in forms are classes from my library.
I do not use the "Load event", because I`m open and close tables included in datainvironment automatically (AutoOpenTable and AutocloseTable property), I`m using the init, refresh and click events.
In code to acess data I`m using the "Select" command to select the table, and the commands "Go Bottom, Go Top, Seek and Skip". I`m using simple indexes.
I do not use Formsets.
The Key set commands are :
Set optimaze on
set refresh to 0,0
set collate to "Machine"
Set reprocess to automatic
set doshistory off
set escape on
set exact on
set exlusive off
set talk off
set view off
....
I`m using CONFIG.FPW to redirect all temporary files to a directory
in the local machine:
TMPFILES=C:\FPAKTEMP
EDITWORK=C:\FPAKTEMP
SORTWORK=C:\FPAKTEMP
PROGWORK=C:\FPAKTEMP
In all my foms I set the property Buffermode to "Optimistic" and the Buffermodeoverride to 1. I`m using the functions "Rlock()" and "Flock()" and Set reprocess to automatic.
I`m using the command "Scatter to memvar" and "Gather from memvar" in Edit mode, and "INSERT - SQL" in Insert mode.
Thanks
Carla
Carla Silva