Frank,
did you also check the results with the Windows memory manager? Maybe ISTAT
performs not correctly.
Jouke
----- Original Message -----
From: Frank Radice <[EMAIL PROTECTED]>
To: RBASE mailing list (E-mail) <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 12:42 AM
Subject: Please try this test
> Try running this in a DOS version of RBase. I ran it using 6.5+ & 6.5++.
> Ran it on a computer running WIN98.
>
> To keep things as simple as possible, I started in the directory where
RBASE
> is located and copied the CONCOMP DB to this directory.
>
> I wrote 2 simple command files M1 & M2 as follows:
>
> M1 was:
>
> CLS
> SEL ALL FROM Sys_Columns WHERE Sys_Column_Name = 'Sys_Query'
> SET V vMemStat INT = (ISTAT('MEMORY'))
> WRI .vMemStat AT 10 10
>
> ------------------
> M2 was:
>
> CLS
> SEL ALL FROM Product WHERE Model = 'PB3050'
> SET V vMemStat INT = (ISTAT('MEMORY'))
> WRI .vMemStat AT 10 10
>
> -------------------------------------------
>
> Start RBase with: RBASE65 -R
> Get to R>
> CONN CONCOMP
> RUN M1 (or RUN M2)
> (Run this multiple times and watch the results)
>
> My results: The MEMORY value always stayed the same (approx 58,000,000
with
> 64MB memory)
>
> ----------------------------------------
> Now try it starting with: RBASE65 -K64 -R (64 is the reported default
> value, if no "K" specified)
> (remember to CONN CONCOMP)
>
> My results: The MEMORY value decreased 65,536 each time M2 was run and it
> decreased 2,424,832 each time M1 was run. The value decreased until it
> reached 65,500 and stayed there without any visible effects.
>
> ----------------------------------------
> Now try starting with: RBASE65 -K1 -R
>
> My results: The MEMORY value decreased 4,096 each time M2 was run and it
> decreased 147,456 each time M1 was run. When the value decreased to about
> 18,000,000 the response time greatly slowed. (Takes a lot of "RUNS" to do
> this depending on your installed memory. You could run the programs in a
> loop to make it easier to do.)
>
> -----------------------------------------
> Now try starting with: RBASE -K1000 -R
>
> My results: The MEMORY value decreased 1,024,000 each time M2 was run and
> it decreased 19,456,000 each time M1 was run. After running M2 about 50
> times (or running M1 3 times), I was dropped back to the C> with the
message
> "Insufficient memory to load Protected Mode R:Base"
>
> --------------------------------------------------------------
> Any thoughts?
>
