Frank,
Try Multi on and Static On.
In multi user mode the system has to do a lot more to ensure concurency
control. By turning static on, the system does not have to worry about
structure changes, so it eliiminates some overhead.
Troy
>===== Original Message From [EMAIL PROTECTED] =====
>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]
Troy Sosamon
Denver Co
[EMAIL PROTECTED]
