General information
Category:
Coding, syntax & commands
Title:
Which will be faster
Environment versions
Network:
Windows 2000 Server
Dear Experts,
I have 2 questions that I want to know about.
Question 1:
Code 1:
SET EXCLUSIVE OFF
USE \\MyServerPath\MyTable
IF FLOCK()
INDEX ON MyField TO SYS(2015)
UNLOCK
ENDIF
or
Code 2:
SET EXCLUSIVE OFF
USE \\MyServerPath\MyTable
IF FLOCK()
INDEX ON MyField TO SYS(2023)+"\"+SYS(2015) && Temporary file path
UNLOCK
ENDIF
Which one will faster Code1 or Code2
Question 2:
Which command of following will open table faster
USE \\MyServer\MyTable
or
USE (Maped Drive):\MyTable
Thnx
Jignesh
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only