this little example executed in a lan environment in which the server is linux, microsoft or simply a shared folder from a windows 10 client, highlights that if the dbf table is open from another user in another pc or even in the same pc the execution speed is very very fast. The same speed as when the dbf table is opened only by this program.
Things also change a lot when the cdx file is opened in addition to the dbf file.
The execution speed decreases an half second till five six seconds
I'd like to know which is the problem, if we can talking of problems or if is normal this enormeus difference of speed. In my opinion is not normal.
recap:
- DBF AND CDX OPENED FROM ANOTHER USER SLOW
- ONLY DBF OPENED FROM ANOTHER USER: FAST
- DBF AND CDX OPENED ONLY FROM ME
I understand that indices are fundamental but they are very heavy. I hope I'm doing something wrong
Many thanks to all
Marco
Code: Select all | Expand
ANNOUNCE RDDSYS
FUNCTION MAIN( )
CLS
SET DELETED ON
SET EXCLUSIVE OFF
SET AUTOPEN OFF
DO WHILE .T.
nInizio := SECONDS()
SELECT 0
USE m:\marco\JALA
SET INDEX TO m:\marco\JALA
GO TOP
? SECONDS() - nInizio
nInizio := SECONDS()
DO WHILE !EOF()
@ 10 , 10 SAY field->bol_lav
SKIP
ENDDO
? RECNO() , SECONDS() - nInizio
IF INKEY( 1 ) = 27
EXIT
ENDIF
USE
ENDDO
RETURN NIL
INIT PROCEDURE RddInit
REQUEST DBFFPT
REQUEST DBFCDX
rddSetDefault( "DBFCDX" )
RETURN
