OpenEdge: Scatter Factor

Yahoo Archive
1
I haven't done a D/L since going live in 2007.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Miguel Santillan
Sent: Thursday, February 07, 2013 5:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: OpenEdge: Scatter Factor





I had a SF of 8.5 on 2/2012, did a DL and it went to 4.1. I really didn't
see much a performance change. Db was 20Gb at the time. I don't believe we
had done a D/L since 3/2010 when we went live with 9.05.

On 1/2013, SF was at 6.8 and it went to 3.2 after the D/L. Db is not 29Gb.

Don't did it is a "Holy Crap" situation...

Miguel A. Santillan
Compass Components, Inc.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Joe Rojas
Sent: Thursday, February 07, 2013 12:28 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OpenEdge: Scatter Factor

Hi All,

I was talking with Epicor support and they were saying that my database
was in need of a dump and load because of the Scatter Factor of some of
our larger tables.

I was trying to figure out how to interpret the Scatter Factor values.

The OpenEdge DB Admin guide says:

"A value of 1 indicates that the records occupy completely contiguous
database blocks. A value of 2 indicates that the records are scattered
ten times wider than the ideal...If the value is 1.5 or greater,
performance will be poor for sequential record access, and dumping and
loading the data might be warranted. A value of 1.5 or greater might
also reduce performance for random access; however, this depends on the
system type and the application."

So if I have a table with 500K+ records and a Scatter Factor of 7, is
that a "Holy Crap" kind of situation or is not really as bad as it
sounds?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> |
www.matsinc.comhttp://www.matsinc.com> Ask us about our clean, green and
beautiful matting and flooring

This message is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in this
email are solely those of the author and do not necessarily represent those
of the company.

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

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



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2238 / Virus Database: 2639/5587 - Release Date: 02/07/13




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2238 / Virus Database: 2639/5587 - Release Date: 02/07/13

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



I was talking with Epicor support and they were saying that my database
was in need of a dump and load because of the Scatter Factor of some of
our larger tables.



I was trying to figure out how to interpret the Scatter Factor values.



The OpenEdge DB Admin guide says:

"A value of 1 indicates that the records occupy completely contiguous
database blocks. A value of 2 indicates that the records are scattered
ten times wider than the ideal...If the value is 1.5 or greater,
performance will be poor for sequential record access, and dumping and
loading the data might be warranted. A value of 1.5 or greater might
also reduce performance for random access; however, this depends on the
system type and the application."



So if I have a table with 500K+ records and a Scatter Factor of 7, is
that a "Holy Crap" kind of situation or is not really as bad as it
sounds?








Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
3
My usual rule of thumb is to D/L any time some of the 'major tables' are
above five.


*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*


On Thu, Feb 7, 2013 at 3:27 PM, Joe Rojas <jrojas@...> wrote:

> **
>
>
> Hi All,
>
> I was talking with Epicor support and they were saying that my database
> was in need of a dump and load because of the Scatter Factor of some of
> our larger tables.
>
> I was trying to figure out how to interpret the Scatter Factor values.
>
> The OpenEdge DB Admin guide says:
>
> "A value of 1 indicates that the records occupy completely contiguous
> database blocks. A value of 2 indicates that the records are scattered
> ten times wider than the ideal...If the value is 1.5 or greater,
> performance will be poor for sequential record access, and dumping and
> loading the data might be warranted. A value of 1.5 or greater might
> also reduce performance for random access; however, this depends on the
> system type and the application."
>
> So if I have a table with 500K+ records and a Scatter Factor of 7, is
> that a "Holy Crap" kind of situation or is not really as bad as it
> sounds?
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
4
I had a SF of 8.5 on 2/2012, did a DL and it went to 4.1. I really didn't see much a performance change. Db was 20Gb at the time. I don't believe we had done a D/L since 3/2010 when we went live with 9.05.

On 1/2013, SF was at 6.8 and it went to 3.2 after the D/L. Db is not 29Gb.

Don't did it is a "Holy Crap" situation...

Miguel A. Santillan
Compass Components, Inc.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Rojas
Sent: Thursday, February 07, 2013 12:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OpenEdge: Scatter Factor



Hi All,

I was talking with Epicor support and they were saying that my database
was in need of a dump and load because of the Scatter Factor of some of
our larger tables.

I was trying to figure out how to interpret the Scatter Factor values.

The OpenEdge DB Admin guide says:

"A value of 1 indicates that the records occupy completely contiguous
database blocks. A value of 2 indicates that the records are scattered
ten times wider than the ideal...If the value is 1.5 or greater,
performance will be poor for sequential record access, and dumping and
loading the data might be warranted. A value of 1.5 or greater might
also reduce performance for random access; however, this depends on the
system type and the application."

So if I have a table with 500K+ records and a Scatter Factor of 7, is
that a "Holy Crap" kind of situation or is not really as bad as it
sounds?





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com<http://www.matsinc.com> Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

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



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