I ran some more tests using my speed test program. I have tried many
variations in the program and still get similar results. I tried it with a
while loop, with a loop using if-then & goto, select ... into..., set v ...
= ..., verify column/row, staticdb on/off, fastlock on/off, whileopt on/off,
etc.
After I run the program, I looked at values for (ISTAT('TotalReads')) and
(ISTAT('TotalLocks')).
(MULTI OFF) TotalReads = 122, TotalLocks = 0 (both with RB6.5++ Win & DOS)
- Both Local & on Network
(MULTI ON) TotalReads = 4044, TotalLocks = 3 (both with RB6.5++ Win & DOS)
- Both Local & on network
The difference in the # of locks don't seem significant or unusual.
However, there are 33 times as many Reads when multi is ON. Why? What is
it reading? This seems to be the reason for the speed difference I
observed.
Frank Radice
[EMAIL PROTECTED]
