-B parameter

Thanks to all who replied offline.

Patrick

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, November 21, 2001 1:42 PM
To: Vantage User Group on Onelist (E-mail)
Subject: [Vantage] -B parameter


How high have some of you set this?
If we calculate per user we can compare more evenly.

I have set mine to 140000 which is about 560mb with 55 users that's 2545
per user or 10mb per user depending on how you want to look at it.

I know the recommendation is about 1/2 your server RAM.

Anyone seeing performance increases by going higher?
How high have some of you set this?
If we calculate per user we can compare more evenly.

I have set mine to 140000 which is about 560mb with 55 users that's 2545
per user or 10mb per user depending on how you want to look at it.

I know the recommendation is about 1/2 your server RAM.

Anyone seeing performance increases by going higher?

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a
Have a safe and happy thanksgiving holiday all our friends to the south.

Ron Newell
IT/MIS
Neon Products
1695 Sargent Ave.
Winnipeg, MB R3H 0C4 CANADA

http://www.neon-products.com/
mailto:rnewell@...
Patrick -

If server's only used for Vantage & Progress - 75-80% has been found safe.
Hope this helps,
Misha 1, Ltd.
Calvin Dekker
Tel: 630-893-1305
Fax: 630-893-1307
email: calvin@...

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, November 21, 2001 1:42 PM
To: Vantage User Group on Onelist (E-mail)
Subject: [Vantage] -B parameter


How high have some of you set this?
If we calculate per user we can compare more evenly.

I have set mine to 140000 which is about 560mb with 55 users that's 2545
per user or 10mb per user depending on how you want to look at it.

I know the recommendation is about 1/2 your server RAM.

Anyone seeing performance increases by going higher?

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a

Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
At 02:41 PM 11/21/2001, you wrote:
>I have set mine to 140000 which is about 560mb with 55 users that's 2545
>per user or 10mb per user depending on how you want to look at it.

The memory is shared between all the server processes to buffer the
database. I think it's better to base if on the size of your data (the .D1
file) rather than the number of users.

>I know the recommendation is about 1/2 your server RAM.
>Anyone seeing performance increases by going higher?

I'd say that recommendation is obsolete with memory prices the way they are
today. Setting -B any higher than the actual size of the data files won't
do any good, but if you can make equal, that should give the best
performance. Given the size of DB most of us are running, it's not too
expensive to do.

Also... you need to set -B separately for each database on your server. If
you set it huge in the global config file, then you'll be wasting memory on
your training / testing DB. I can give some pointers on where to set it,
if anyone needs them.

-Wayne Cox
Patrick,
With 512MB of RAM, I had set our -B to 40,000. But we were soon finding that the Server was running out of resources on a weekly basis. Lowering it to 20,000 seemed to relieve the limited resources issue, while it didn't seem to hurt performance too much on Vantage. 18 users.

Troy Funte
Liberty Electronics


----- Original Message -----
From: Winter, Patrick
To: Vantage User Group on Onelist (E-mail)
Sent: Wednesday, November 21, 2001 2:41 PM
Subject: [Vantage] -B parameter


How high have some of you set this?
If we calculate per user we can compare more evenly.

I have set mine to 140000 which is about 560mb with 55 users that's 2545
per user or 10mb per user depending on how you want to look at it.

I know the recommendation is about 1/2 your server RAM.

Anyone seeing performance increases by going higher?

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a

Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
-B sets the size of the buffer pool used to read records from the
database to memory. It is most affected by the number of users, and the
number of different records they are reading. Thus a large number of
users reading a small stable set of records will not need a vary large
buffer pool. A few users reading a very large number of different
records will need a large pool. It is the number of users, and the type
of activity that impacts your -B setting. DB size is not relevant.

Wayne Cox wrote:
>
> At 02:41 PM 11/21/2001, you wrote:
> >I have set mine to 140000 which is about 560mb with 55 users that's 2545
> >per user or 10mb per user depending on how you want to look at it.
>
> The memory is shared between all the server processes to buffer the
> database. I think it's better to base if on the size of your data (the .D1
> file) rather than the number of users.
>
> >I know the recommendation is about 1/2 your server RAM.
> >Anyone seeing performance increases by going higher?
>
> I'd say that recommendation is obsolete with memory prices the way they are
> today. Setting -B any higher than the actual size of the data files won't
> do any good, but if you can make equal, that should give the best
> performance. Given the size of DB most of us are running, it's not too
> expensive to do.
>
> Also... you need to set -B separately for each database on your server. If
> you set it huge in the global config file, then you'll be wasting memory on
> your training / testing DB. I can give some pointers on where to set it,
> if anyone needs them.
>
> -Wayne Cox
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1