We tested with Staticdb on and off - it makes no difference. The only factor that
changes the times dramatically like this is whether or not a second user is connected
to the db. Multi on/off, staticdb on/off with and without fastlocks - only significant
difference is caused by connecting a second user - who need do absolutely nothing,
just connect, to kill the performance. W2000 servers only.
There was a note on the list yesterday about server settings that our network team
will have a look at.
[EMAIL PROTECTED] wrote:
>
> 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]
>
>
__________________________________________________________________
Get your own FREE, personal Netscape Webmail account today at
http://webmail.netscape.com/
