DB tuning: -B param

Yahoo Archive
1
"Didn't see that one. Gotta' URL handy?"

http://eranet.epicor.com/ansbook/vantage/public/3/34/340/340.10mps.htm

Looks like your -B 40000 is a good shot according to the above .htm (with 512MB of RAM on the server, which is what we are using also). Their table estimates the RAM usage at 40000 = 166.5 MB. The rule of thumb is 1/3 to 1/2 of your servers RAM for the -B.

"Report Builder will consume them too."

Ah yes, I forgot about the RB licenses that Progress needs. Does RB also take up a Vantage License? OH, you just answered that one with your last email. (NO, in other words).

Troy

----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Sent: Tuesday, June 05, 2001 11:31 PM
Subject: Re: [Vantage] DB tuning: -B param


At 10:30 PM 6/5/2001 -0400, you wrote:
> I've been looking at the "Startup Guide" from Progress. I'm curious
> what you are using for # users verses Users per broker (which are the -n
> -Mn and -Ma)

Haven't messed with those. Our -n is 30, I think -Mn defaults from that
(n/8 maybe?) If ya' haven't already seen it, you can look at the
Vantage.LG file to see what all the parameters are being set to.

>It looks like I won't ever need 36 users, though if I have only a REAL
>potential of having 24 users on at one time.

Report Builder will consume them too. Not sure about just running a RB
report, though, like from within Vantage.. Will have to test that. The
one user / broker was a work around for the bugs last year. But everything
I've heard suggests that it's not the most efficient way to run things. If
so, your -Mn 18 would be excessive.

>the "performance tips" page on the EraNet site says that

Didn't see that one. Gotta' URL handy?

-WC




Yahoo! Groups Sponsor



To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

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



[Non-text portions of this message have been removed]
2
Hi All...

I'm playing around with some DB server tuning and had a question. I'm
trying to set Progress' -B parameter. This is supposed to control ram
used for buffering or caching DB data.

Problem is, if I increase it in Progress\Startup.pf to an appropriately
large value for our live Vantage DB, it also affects our training and
testing DBs. Memory is cheap, but I really don't need those to be wasting
200MB each! Setting it in Vantage\DB\Vantage.pf doesn't seem to have any
effect.

Is there a way to set this separately for each DB on the server?

-Thanks,
Wayne
3
-B is a server side parameter. You can set it individually by setting the value in the command line that you use to start each server. For example, if you have a shortcut that starts a database server, select the short cut, right click it, and select the
properties. Add, for example, -B 50 to the end of the target line. This will start the database with 50 blocks in the buffer pool.

The startup.pf file is read by all sessions that start, so this is not a good place to put a parameter like -B. It is mostly used for setting things like codepage, numeric format, date format; things that you really want to have completely consistent in all
situations. Almost all parameters can be set on the command line. You can also specify one or more parameter files on the command line (-pf file-name).

HTH

Wayne Cox wrote:

> Hi All...
>
> I'm playing around with some DB server tuning and had a question. I'm
> trying to set Progress' -B parameter. This is supposed to control ram
> used for buffering or caching DB data.
>
> Problem is, if I increase it in Progress\Startup.pf to an appropriately
> large value for our live Vantage DB, it also affects our training and
> testing DBs. Memory is cheap, but I really don't need those to be wasting
> 200MB each! Setting it in Vantage\DB\Vantage.pf doesn't seem to have any
> effect.
>
> Is there a way to set this separately for each DB on the server?
>
> -Thanks,
> Wayne
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
At 10:31 PM 6/4/2001 -0400, you wrote:
>-B is a server side parameter. You can set it individually by setting the
>value in the command line that you use to start each server. For example,
>if you have a

Thanks, William! Good Info.

What I ended up doing was editing Startup.pf to have a reasonable -B (-B
4000) for the single user test DBs (the default based on -n is way too
dinky, if you have any reasonable amount of memory.)

For our production DB, I went into ProControl, DB Details, and added -B
40000 as a "Startup Parameter" This seems to let all the seldom used DBs
run with minimal resources, and kick up the memory for what we really run
from.

My 1/2GB server is finally using over 80MB, and my li'l test box with 64MB
is happy too. If you haven't messed with any of these parameters, you are
probably missing out on a lot of available performance! Will try to post
more details soon.

-Wayne
5
If you are seriously into tuning your server, I would suggest that you surf over to www.pg.com, follow the links to the lists, and subscribe to dba. There are some REALLY expert tuners there, who can give you a lot of advise about how to find out where your
bottle necks are, and what to do about them. Note that this is a very active list, 30-40 messages a day.



Wayne Cox wrote:

> At 10:31 PM 6/4/2001 -0400, you wrote:
> >-B is a server side parameter. You can set it individually by setting the
> >value in the command line that you use to start each server. For example,
> >if you have a
>
> Thanks, William! Good Info.
>
> What I ended up doing was editing Startup.pf to have a reasonable -B (-B
> 4000) for the single user test DBs (the default based on -n is way too
> dinky, if you have any reasonable amount of memory.)
>
> For our production DB, I went into ProControl, DB Details, and added -B
> 40000 as a "Startup Parameter" This seems to let all the seldom used DBs
> run with minimal resources, and kick up the memory for what we really run
> from.
>
> My 1/2GB server is finally using over 80MB, and my li'l test box with 64MB
> is happy too. If you haven't messed with any of these parameters, you are
> probably missing out on a lot of available performance! Will try to post
> more details soon.
>
> -Wayne
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
6
How much memory will -B 40000 actually allocate to Vantage? We have 512MB on our server.

Troy

----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Sent: Monday, June 04, 2001 11:08 PM
Subject: Re: [Vantage] DB tuning: -B param


At 10:31 PM 6/4/2001 -0400, you wrote:
>-B is a server side parameter. You can set it individually by setting the
>value in the command line that you use to start each server. For example,
>if you have a

Thanks, William! Good Info.

What I ended up doing was editing Startup.pf to have a reasonable -B (-B
4000) for the single user test DBs (the default based on -n is way too
dinky, if you have any reasonable amount of memory.)

For our production DB, I went into ProControl, DB Details, and added -B
40000 as a "Startup Parameter" This seems to let all the seldom used DBs
run with minimal resources, and kick up the memory for what we really run
from.

My 1/2GB server is finally using over 80MB, and my li'l test box with 64MB
is happy too. If you haven't messed with any of these parameters, you are
probably missing out on a lot of available performance! Will try to post
more details soon.

-Wayne





Yahoo! Groups Sponsor



To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

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



[Non-text portions of this message have been removed]
7
I believe it is 43 meg per 10000 buffers. I got two answers as to the
max amount Progress will use.... 256 meg or 512 meg max.

You need to "play" with this setting, since it is dependant on your
processor, I/O bus, and disk sub-system.
We found that when we got above 70000, our CPU utilization began to
"peg" out.

Call Epicor, and they will give you some pointers.

Britt Moelling
M&M Manufacturing Co.

Troy Funte wrote:

> How much memory will -B 40000 actually allocate to Vantage? We have
> 512MB on our server.
>
> Troy
>
> ----- Original Message -----
> From: Wayne Cox
> To: vantage@yahoogroups.com
> Sent: Monday, June 04, 2001 11:08 PM
> Subject: Re: [Vantage] DB tuning: -B param
>
>
> At 10:31 PM 6/4/2001 -0400, you wrote:
> >-B is a server side parameter. You can set it individually by
> setting the
> >value in the command line that you use to start each server. For
> example,
> >if you have a
>
> Thanks, William! Good Info.
>
> What I ended up doing was editing Startup.pf to have a reasonable -B
> (-B
> 4000) for the single user test DBs (the default based on -n is way
> too
> dinky, if you have any reasonable amount of memory.)
>
> For our production DB, I went into ProControl, DB Details, and added
> -B
> 40000 as a "Startup Parameter" This seems to let all the seldom
> used DBs
> run with minimal resources, and kick up the memory for what we
> really run
> from.
>
> My 1/2GB server is finally using over 80MB, and my li'l test box
> with 64MB
> is happy too. If you haven't messed with any of these parameters,
> you are
> probably missing out on a lot of available performance! Will try to
> post
> more details soon.
>
> -Wayne
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
> already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
[Yahoo! Website Services- Click Here!]
Yahoo! Website Services- Click Here!

>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
> already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
Britt Moelling
M&M Manufacturing Co.



[Non-text portions of this message have been removed]
8
At 12:21 AM 6/5/2001 , you wrote:
>How much memory will -B 40000 actually allocate to Vantage? We have 512MB
>on our server.

This document on EraNet was what got me started:
http://eranet.epicor.com/ansbook/vantage/public/3/34/340/340.10mps.htm

It says -B 40000 is about 167MB. Before, I had noticed several odd looking
things in the NT Task Manager: I had over 400MB of unused RAM [physical
memory (K) available]; The total virtual memory allocated [commit charge
(k) total] was only 70MB; The biggest Progress process [_mprosrv] was only
5000K. [this is on a 512MB NT4 box]

This is what I've figured out about the various parameter files (I could be
wrong):
Progress\Startup.pf Global server & client settings
Vantage\DB\Vantage.pf Referenced by the .VTG file for client settings
ProControl / Startup Parameters Put your DB specific settings here

I ended up with:
startup.pf: -B 3000 default 6mb for the
test DBs
startup & vantage.pf: -Mm 8192 bigger TCP packets for all
vantage.pf: -Bt 2560 bigger client buffer
space (~10MB)
ProControl for big DB -B 40000 lots 'o' ram for the main thing

There's probably room for more improvement, but it's a heck of a lot better
than the default settings.

Anyone know if startup.pf is used during single-user operations, such as
version upgrades? Might be able to speed up some of those slow conversions.

-Wayne
9
At 11:33 AM 6/5/2001 , you wrote:
>I believe it is 43 meg per 10000 buffers. I got two answers as to the
>max amount Progress will use.... 256 meg or 512 meg max.

The DB Admin Guide says a maximum of 500,000 blocks (I'd bet that's really
524,288) which is 2GB with 4K blocks.

(That's actually from the Progress 9.1 book, available in oh-so-convenient
.pdf format)

-WC
10
Yes. startup.pf is used for single user, and multi-user startup. Also the proper URL for the Progress E-mail Group (PEG) is www.peg.com

Wayne Cox wrote:

> At 12:21 AM 6/5/2001 , you wrote:
> >How much memory will -B 40000 actually allocate to Vantage? We have 512MB
> >on our server.
>
> This document on EraNet was what got me started:
> http://eranet.epicor.com/ansbook/vantage/public/3/34/340/340.10mps.htm
>
> It says -B 40000 is about 167MB. Before, I had noticed several odd looking
> things in the NT Task Manager: I had over 400MB of unused RAM [physical
> memory (K) available]; The total virtual memory allocated [commit charge
> (k) total] was only 70MB; The biggest Progress process [_mprosrv] was only
> 5000K. [this is on a 512MB NT4 box]
>
> This is what I've figured out about the various parameter files (I could be
> wrong):
> Progress\Startup.pf Global server & client settings
> Vantage\DB\Vantage.pf Referenced by the .VTG file for client settings
> ProControl / Startup Parameters Put your DB specific settings here
>
> I ended up with:
> startup.pf: -B 3000 default 6mb for the
> test DBs
> startup & vantage.pf: -Mm 8192 bigger TCP packets for all
> vantage.pf: -Bt 2560 bigger client buffer
> space (~10MB)
> ProControl for big DB -B 40000 lots 'o' ram for the main thing
>
> There's probably room for more improvement, but it's a heck of a lot better
> than the default settings.
>
> Anyone know if startup.pf is used during single-user operations, such as
> version upgrades? Might be able to speed up some of those slow conversions.
>
> -Wayne
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
11
Is that the max File size, or buffers? Where did you get the DB Admin
Guide? Can I get my hands on one?

Britt Moelling
M&M Manufacturing

Wayne Cox wrote:

> At 11:33 AM 6/5/2001 , you wrote:
> >I believe it is 43 meg per 10000 buffers. I got two answers as to
> the
> >max amount Progress will use.... 256 meg or 512 meg max.
>
> The DB Admin Guide says a maximum of 500,000 blocks (I'd bet that's
> really
> 524,288) which is 2GB with 4K blocks.
>
> (That's actually from the Progress 9.1 book, available in
> oh-so-convenient
> .pdf format)
>
> -WC
>
>
>
> Yahoo! Groups Sponsor
[Check out great fares at Orbitz!]

>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
> already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
Britt Moelling
M&M Manufacturing Co.



[Non-text portions of this message have been removed]
12
The Guide can be found here. It should be able to answer your questions.

http://www.progress.com/v9/documentation/start.htm

-----Original Message-----
From: Britt Moelling [mailto:bmoelling@...]
Sent: Tuesday, June 05, 2001 5:52 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] DB tuning: -B param


Is that the max File size, or buffers? Where did you get the DB Admin
Guide? Can I get my hands on one?

Britt Moelling
M&M Manufacturing

Wayne Cox wrote:

> At 11:33 AM 6/5/2001 , you wrote:
> >I believe it is 43 meg per 10000 buffers. I got two answers as to
> the
> >max amount Progress will use.... 256 meg or 512 meg max.
>
> The DB Admin Guide says a maximum of 500,000 blocks (I'd bet that's
> really
> 524,288) which is 2GB with 4K blocks.
>
> (That's actually from the Progress 9.1 book, available in
> oh-so-convenient
> .pdf format)
>
> -WC
>
>
>
> Yahoo! Groups Sponsor
[Check out great fares at Orbitz!]

>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
> already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
Britt Moelling
M&M Manufacturing Co.



[Non-text portions of this message have been removed]


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
13
Version 9.1 at least books are available in pdf format at the progress web site. Some earlier versions are also available in dynatext format there as well. I would have thought that you would have received the progress E-Docs cd with your copy of Progress.
As far as I know, it is always included with all versions of Progress when they ship from Bedford.

Britt Moelling wrote:

> Is that the max File size, or buffers? Where did you get the DB Admin
> Guide? Can I get my hands on one?
>
> Britt Moelling
> M&M Manufacturing
>
> Wayne Cox wrote:
>
> > At 11:33 AM 6/5/2001 , you wrote:
> > >I believe it is 43 meg per 10000 buffers. I got two answers as to
> > the
> > >max amount Progress will use.... 256 meg or 512 meg max.
> >
> > The DB Admin Guide says a maximum of 500,000 blocks (I'd bet that's
> > really
> > 524,288) which is 2GB with 4K blocks.
> >
> > (That's actually from the Progress 9.1 book, available in
> > oh-so-convenient
> > .pdf format)
> >
> > -WC
> >
> >
> >
> > Yahoo! Groups Sponsor
> [Check out great fares at Orbitz!]
>
> >
> > To access the Files Section of our Yahoo!Group for Report Builder and
> > Crystal Reports and other 'goodies', please go to:
> > http://groups.yahoo.com/group/vantage/files/. Note: You must have
> > already linked your email address to a yahoo id to enable access.
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> --
> Britt Moelling
> M&M Manufacturing Co.
>
> [Non-text portions of this message have been removed]
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
14
At 09:19 PM 6/5/2001 -0400, you wrote:
>I would have thought that you would have received the progress E-Docs cd
>with your copy of Progress. As far as I know, it is always included with
>all versions of Progress when they ship from Bedford.

Back when we first bought Vantage (June '99) we got the Progress 8.3B
package including the documentation CDs and a couple books drop shipped
directly from PSC. Since then, Epicor has sent out a bundled CD with both
Vantage and a pared down Progress distribution. Dunno' if PSC knows we exist.

BTW... anyone know what the Progress Enterprise DB actually costs Epicor
for resale purposes? Just curious; never saw it itemized. Our previous
ERP vendor charged us $13k for a DB license -- we later found out quite a
few of their 50 or 60 customers had been issued the same serial number, and
the DB company thought they had only re-sold 9 copies! [No! - I do not
suspect Epicor of any such scamming - they're too high profile to get away,
even IF they were that dishonest!]

Like the other guys said... Starting with 9.1 the complete library is in
PDF and free for download. We're only on 9.0, but I figure the elementary
level I'm at, there can't be that many differences. The "DynaText" format
of the older docs is nearly unusable.

> > Is that the max File size, or buffers? Where did you get the DB Admin

That's max memory that can be allocated to buffers. With the multi-volume
stuff, the DB size should be nearly infinite. The Admin Guide has a whole
chapter (3?) on the "limitations".

-WC
15
Wayne,
I've been looking at the "Startup Guide" from Progress. I'm curious what you are using for # users verses Users per broker (which are the -n -Mn and -Ma) parameters. We have 10 DataCollection licenses (but only use 6), and 18 regular licenses. Our parameters read: -n 36 -Mn 18 -Ma 2, which translated means 36 users, Start 18 brokers, and allocate 2 users per broker. This is what Epicor advised me to put in before I knew what an Mn was. It looks like I won't ever need 36 users, though if I have only a REAL potential of having 24 users on at one time.

Have you messed with those parameters all? The "performance tips" page on the EraNet site says that some have started one broker per user. Have you tried that?

Troy Funte
Liberty Electronics
----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Sent: Tuesday, June 05, 2001 10:10 PM
Subject: Re: [Vantage] DB tuning: -B param


At 09:19 PM 6/5/2001 -0400, you wrote:
>I would have thought that you would have received the progress E-Docs cd
>with your copy of Progress. As far as I know, it is always included with
>all versions of Progress when they ship from Bedford.

Back when we first bought Vantage (June '99) we got the Progress 8.3B
package including the documentation CDs and a couple books drop shipped
directly from PSC. Since then, Epicor has sent out a bundled CD with both
Vantage and a pared down Progress distribution. Dunno' if PSC knows we exist.

BTW... anyone know what the Progress Enterprise DB actually costs Epicor
for resale purposes? Just curious; never saw it itemized. Our previous
ERP vendor charged us $13k for a DB license -- we later found out quite a
few of their 50 or 60 customers had been issued the same serial number, and
the DB company thought they had only re-sold 9 copies! [No! - I do not
suspect Epicor of any such scamming - they're too high profile to get away,
even IF they were that dishonest!]

Like the other guys said... Starting with 9.1 the complete library is in
PDF and free for download. We're only on 9.0, but I figure the elementary
level I'm at, there can't be that many differences. The "DynaText" format
of the older docs is nearly unusable.

> > Is that the max File size, or buffers? Where did you get the DB Admin

That's max memory that can be allocated to buffers. With the multi-volume
stuff, the DB size should be nearly infinite. The Admin Guide has a whole
chapter (3?) on the "limitations".

-WC



Yahoo! Groups Sponsor






To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

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



[Non-text portions of this message have been removed]
16
At 10:30 PM 6/5/2001 -0400, you wrote:
> I've been looking at the "Startup Guide" from Progress. I'm curious
> what you are using for # users verses Users per broker (which are the -n
> -Mn and -Ma)

Haven't messed with those. Our -n is 30, I think -Mn defaults from that
(n/8 maybe?) If ya' haven't already seen it, you can look at the
Vantage.LG file to see what all the parameters are being set to.

>It looks like I won't ever need 36 users, though if I have only a REAL
>potential of having 24 users on at one time.

Report Builder will consume them too. Not sure about just running a RB
report, though, like from within Vantage.. Will have to test that. The
one user / broker was a work around for the bugs last year. But everything
I've heard suggests that it's not the most efficient way to run things. If
so, your -Mn 18 would be excessive.

>the "performance tips" page on the EraNet site says that

Didn't see that one. Gotta' URL handy?

-WC
17
Remember that -n is not the number of Licensed Users, but the number of user connections. 1 person connected 3 times (from a Progress point of view) is 1 licensed user, but n should be set to 3 so that adequate resources are available. The -n number is used
in a number of places to calculate how much this or that Progress gabs at startup. So each ODBC connection counts, each Report Builder connection counts; if you have background batch processes running, they count. And of course your actual warm bodies count.

PS. I understand from the Epicor point of view, 1 person connected 3 times is 3 users.

Wayne Cox wrote:

> At 10:30 PM 6/5/2001 -0400, you wrote:
> > I've been looking at the "Startup Guide" from Progress. I'm curious
> > what you are using for # users verses Users per broker (which are the -n
> > -Mn and -Ma)
>
> Haven't messed with those. Our -n is 30, I think -Mn defaults from that
> (n/8 maybe?) If ya' haven't already seen it, you can look at the
> Vantage.LG file to see what all the parameters are being set to.
>
> >It looks like I won't ever need 36 users, though if I have only a REAL
> >potential of having 24 users on at one time.
>
> Report Builder will consume them too. Not sure about just running a RB
> report, though, like from within Vantage.. Will have to test that. The
> one user / broker was a work around for the bugs last year. But everything
> I've heard suggests that it's not the most efficient way to run things. If
> so, your -Mn 18 would be excessive.
>
> >the "performance tips" page on the EraNet site says that
>
> Didn't see that one. Gotta' URL handy?
>
> -WC
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/