I'm not sure how related this is but I have seen a massive memory leak of
some sort when using a large iteration While loop that creates a cursor
(cursor is reused in the loop). All available memory (Virtual and Physical)
is eaten and will not be released until the RBase DOS window is completely
closed. This only happens on Win2k machines.
All in all we've seen horrible performance with Rbase 6.5 in a DOS window
under Win2k. Tried everything from using NTVDM process window to using a
32-bit CMD window, and all memory settings in between.
Eric
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Albert Berry
Sent: Monday, June 25, 2001 8:01 AM
To: [EMAIL PROTECTED]
Subject: Re: SET MULTI vs speed
I am unable to replicate your results, with one user connected and only the
MULTI setting changed.
We have been working, however, with RBTI on speed problems with RBase 6.1A,
6.5+, 6.5++ and 6.5++, DOS and Win, on Windows 2000 servers that are similar
to those you experienced. The difference is whether or not one or two users
is connected, always with MULTI ON.
----- Original Message -----
From: "Frank Radice" <[EMAIL PROTECTED]>
To: "RBASE mailing list (E-mail)" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, June 24, 2001 10:55 PM
Subject: SET MULTI vs speed
> I wrote a simple CMD file that selected 3 values from a table (integer,
> text10 & text25) and displayed the resulting value. The integer values
run
> from 1 to 1000. I put the select & write in a WHILE loop and incremented
an
> int var so that it runs thru the loop 1000 times (selecting the row with
> the corresponding int value) & displays the results. I had it calculate
the
> time it took & display that value.
> The integer in the table is indexed.
>
> I got the following results.
>
> Database on MULTI setting Version Time, sec
> Speed factor
> ------------------ -------------------- ------------------------------
--
> ------------- ------------------
> Local drive C ON 6.5++ DOS 4.80
> Local drive C OFF 6.5++ DOS 1.21
> 4x faster
>
> speed ratio = 4.6
> Network ON 6.5++ DOS 27.85
> Network OFF 6.5++ DOS 1.23
> 18.6x faster
>
> --------------------------------------------------------------------------
--
> --------------------------------------------
>
> Local drive C ON 6.5++ WIN 3.57
> Local drive C OFF 6.5++ WIN 1.32
> 2.7x faster
>
> speed ratio = 4.6
> Network ON 6.5++ WIN 17.14
> Network OFF 6.5++ WIN 1.36
> 12.6x faster
>
> =============================================================
> The time is an average for several runs. I used computers (with approx
the
> same processor speed) running both Win98 & Win2000 and got similar
results.
> The network server is running Win2000.
>
> The 6.5++ WIN seems to run a little faster with MULTI ON and a little
slower
> with MULTI OFF, relative to 6.5++ DOS but the ratio of the speed with
MULTI
> ON for Local vs Network are both about 4.6 for both DOS & WIN versions.
> The speed with MULTI OFF does not vary significantly for Local vs
Network.
>
> Why does SET MULTI ON cause such a huge speed degration? Why would MULTI
> ON cause it to run slower on a network then on a local drive, whereas,
MULTI
> OFF runs the same on a network and/or local drive?
>
> Has anyone else observe this kind of behavior?
>
> Frank Radice
>
> [EMAIL PROTECTED]
>
