Request for simple speed test/Change Log Housekeeping

system · March 21, 2011, 5:19am

Did u notice any difference running this?

--- In vantage@yahoogroups.com, "halm180" <Mis@...> wrote:
>
> Thank you sir!
>
>
> --- In vantage@yahoogroups.com, "Chris Robisch" <bluewine@> wrote:
> >
> > Use the Database Purge and Summarize under System Management\Utilities. You can purge the Job Details, Indirect Labor, Journal Details and the Change Log.
> >
> > ----- Original Message -----
> > From: "halm180" <Mis@>
> > To: <vantage@yahoogroups.com>
> > Sent: Friday, March 18, 2011 10:28 AM
> > Subject: [Vantage] Re: Request for simple speed test/Change Log Housekeeping
> >
> >
> > >
> > > --- In vantage@yahoogroups.com, "Ned" <TechnoBabbly@> wrote:
> > >>
> > >> One thing I have found useful is to use the D&L process as an opportunity to
> > >> flush tables like the Chglog table, which can speed things up considerably
> > >> since the DB as a whole is smaller up to 75% in some cases, but you do lose
> > >> your Change log Data up to that point.
> > >
> > > Ned:
> > > What steps are you following to flush the ChgLog table? Are you deleting records between the Dump and Load stages? I have considered doing this but need to build up the confidence. Any precautions or suggestions? Thank you for any and all suggestions.
> > >
> > > Peter Dunbar
> > > Halm Industries Co., Inc.
> >
> > [Non-text portions of this message have been removed]
> >
>

system · March 17, 2011, 1:08pm

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in
the Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@...
<blocked::mailto:len.hartka@...>

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

system · March 17, 2011, 1:14pm

I just did this test on the training database(it would be better to do it on
this DB for benchmarking because most of us have that)

about 4 seconds

9.05.603
SQL 64 non unidata

hope this helps.

also, we did notice a speed improvement after going to 603

Nick

On Thu, 17 Mar 2011 13:08:08 -0400
"Len Hartka" <len.hartka@...> wrote:
Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5
(Informix)

One specific item is: In Quote entry, Line-Entry,
After you type in
the Part# and hit [Enter], it takes 15 seconds for the
screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@...
<blocked::mailto:len.hartka@...>

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary
and/or confidential information. If you are not the
intended recipient, please notify the sender immediately
by reply e-mail or at 410-472-2900 and then delete the
message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications
you are urged to protect against viruses.

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

system · March 17, 2011, 1:26pm

Is your Quote Entry customized? Have you done a dump and load of the
database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in
the Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...
<mailto:len.hartka%40sunautomation.com> >

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

system · March 17, 2011, 2:07pm

Good Day Blake:

Thanks for the suggestion - no, we have not done that.
Have you? Did it speed things up?

You did not indicate how long it takes on your system.

len.hartka@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Thursday, March 17, 2011 1:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Request for simple speed test

Is your Quote Entry customized? Have you done a dump and load of the
database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in
the Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com> >

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

system · March 17, 2011, 2:20pm

We've had similar problems when we first started using Vantage but we
aren't on E9. We're on Vantage 8.03.408B. A dump and load helped
significantly. I do them regularly... usually once every 3-4 months.
Another thing to confirm is that if you have Quote customized, open it
with the base form and see how long it takes to pull in a part. If it's
a lot faster then something is wrong with your customization, if it
takes just as long then a dump and load would be best. Currently it
takes about 1-2 seconds to pull a part into Quote. Like I said we
struggled with this type of behavior until we got settled in the version
we currently have... which is also when we started to administer the
dump and loads.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 2:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Request for simple speed test

Good Day Blake:

Thanks for the suggestion - no, we have not done that.
Have you? Did it speed things up?

You did not indicate how long it takes on your system.

len.hartka@... <mailto:len.hartka%40sunautomation.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, March 17, 2011 1:26 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Is your Quote Entry customized? Have you done a dump and load of the
database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in
the Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com> >

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

system · March 17, 2011, 2:42pm

Len,
if you want, I can run your system log through and analyzer
send me a zip file of your log
also, send me the tracing file for the quote transaction
thanks
motty

--- In vantage@yahoogroups.com, "Len Hartka" <len.hartka@...> wrote:
>
> Good Day:
>
> We continue to chase slowness in E9.
>
> Sun went live on 11/29/10
> on Epicor 9, 9.05.601B SQL-Unidata
> Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
>
> One specific item is: In Quote entry, Line-Entry, After you type in
> the Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
> In Order-Entry it is only 2-4 seconds
>
> 1. Do have a similar delay on your system?
> 2. Version?
> 3. Progress, SQL, or SQL-Unidata
> 4. number of Part#s - we have 280,000
>
>
>
> len.hartka@...
> <blocked::mailto:len.hartka@...>
>
>
> **************************************************************
>
> Sun Automation Group
>
> Celebrating
>
> 25 Years of Service
>
> to the Corrugated Industry
>
> **************************************************************
>
>
>
>
> This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
>
> [Non-text portions of this message have been removed]
>

system · March 17, 2011, 3:03pm

9.05.602
Progress x64
Number of parts: 10256
Transaction time: 2 seconds

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Thursday, March 17, 2011 11:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in
the Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@...<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...<mailto:len.hartka%40sunautomation.com>>

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

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

system · March 18, 2011, 9:32am

Good Day Blake:

I am not sure what you mean by "Dump and Load".

Could you explain a little.

Len

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Thursday, March 17, 2011 1:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Request for simple speed test

Is your Quote Entry customized? Have you done a dump and load of the
database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in
the Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com> >

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

system · March 18, 2011, 9:39am

In simplest terms, dump the contents of every table into a text file. Then one at a time load the contents back in to a empty db. Each table's data would then be located together instead of being scattered all over the place....

--- In vantage@yahoogroups.com, "Len Hartka" <len.hartka@...> wrote:
>
> Good Day Blake:
>
> I am not sure what you mean by "Dump and Load".
>
> Could you explain a little.
>
>
> Len
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Blake Clemens
> Sent: Thursday, March 17, 2011 1:26 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Request for simple speed test
>
>
>
>
> Is your Quote Entry customized? Have you done a dump and load of the
> database?
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Len Hartka
> Sent: Thursday, March 17, 2011 1:08 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Request for simple speed test
>
> Good Day:
>
> We continue to chase slowness in E9.
>
> Sun went live on 11/29/10
> on Epicor 9, 9.05.601B SQL-Unidata
> Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
>
> One specific item is: In Quote entry, Line-Entry, After you type in
> the Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
> In Order-Entry it is only 2-4 seconds
>
> 1. Do have a similar delay on your system?
> 2. Version?
> 3. Progress, SQL, or SQL-Unidata
> 4. number of Part#s - we have 280,000
>
> len.hartka@... <mailto:len.hartka%40sunautomation.com>
> <mailto:len.hartka%40sunautomation.com>
> <blocked::mailto:len.hartka@...
> <mailto:len.hartka%40sunautomation.com>
> <mailto:len.hartka%40sunautomation.com> >
>
> **************************************************************
>
> Sun Automation Group
>
> Celebrating
>
> 25 Years of Service
>
> to the Corrugated Industry
>
> **************************************************************
>
> This e-mail and any attachments may contain proprietary and/or
> confidential information. If you are not the intended recipient, please
> notify the sender immediately by reply e-mail or at 410-472-2900 and
> then delete the message without using, disseminating, or copying this
> message or any portion thereof. With e-mail communications you are urged
> to protect against viruses.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
>
> [Non-text portions of this message have been removed]
>

system · March 18, 2011, 9:39am

Sure... "Dump & Load" is a procedure done to the Vantage database.
Through various steps you take the database and run it through some
processes that clean out all the "bad" data. You then restore the newly
"cleaned" up data. It typically makes your Vantage wait times a lot
shorter. For example, there is a certain canned Vantage financial
report that takes about 3 minutes to run after a dump and load. After
about three months after the dump and load that same report takes 40
minutes. That is how I know its time to run a dump and load again.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Len Hartka
Sent: Friday, March 18, 2011 9:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Request for simple speed test

Good Day Blake:

I am not sure what you mean by "Dump and Load".

Could you explain a little.

Len

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, March 17, 2011 1:26 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Is your Quote Entry customized? Have you done a dump and load of the
database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in
the Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com> >

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

system · March 18, 2011, 10:23am

Good Day Motty:

1. "Zip of log file". Which log? which server?

2. Below is the trace for Quote # 1759, Part# ( ---010544--). Cust#
Le0979
Started with clicking "add-new-line" ended with adding quantity,
then save.

len.hartka@...

****************************************************************
begin
cket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>GetNewQuoteDtl</methodName>
<returnType>void</returnType>
<localTime>3/18/2011 10:11:55:1580532 AM</localTime>
<executionTime>671.5095</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet"
/></parameter>
<parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote" /></parameter>
<parameter name='quoteNum' type='System.Int32'

><![CDATA[1759]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
<methodName>GetRowsKeepIdleTime</methodName>
<returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
<localTime>3/18/2011 10:12:11:6334607 AM</localTime>
<executionTime>62.466</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClauseSysRptLst' type='System.String'

><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction

<> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>GetPartXRefInfo</methodName>
<returnType>void</returnType>
<localTime>3/18/2011 10:12:14:6162122 AM</localTime>
<executionTime>109.3155</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='partNum' type='System.String'

><![CDATA[---010544--]]></parameter>

<parameter name='sysRowID' type='System.String'

><![CDATA[]]></parameter>

<parameter name='rowType' type='System.String'

><![CDATA[]]></parameter>

<parameter name='uomCode' type='System.String'

><![CDATA[]]></parameter>

<parameter name='serialWarning' type='System.String'

><![CDATA[]]></parameter>

<parameter name='questionString' type='System.String'

><![CDATA[]]></parameter>

<parameter name='multipleMatch' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>CheckPrePartInfo</methodName>
<returnType>void</returnType>
<localTime>3/18/2011 10:12:14:7255277 AM</localTime>
<executionTime>234.2475</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='quoteNum' type='System.Int32'

><![CDATA[1759]]></parameter>

<parameter name='quoteLine' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='fieldName' type='System.String'

><![CDATA[PartNum]]></parameter>

<parameter name='partNum' type='System.String'

><![CDATA[---010544--]]></parameter>

<parameter name='vMessage' type='System.String'

><![CDATA[]]></parameter>

<parameter name='vBMessage' type='System.String'

><![CDATA[]]></parameter>

<parameter name='vPMessage' type='System.String'

><![CDATA[]]></parameter>

<parameter name='vSubAvail' type='System.Boolean'

><![CDATA[]]></parameter>

<parameter name='vMsgType' type='System.String'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Part</businessObject>
<methodName>PartIsSalesKit</methodName>
<returnType>bool</returnType>
<localTime>3/18/2011 10:12:14:9597752 AM</localTime>
<executionTime>78.0825</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='partNumber' type='System.String'

><![CDATA[]]></parameter>

<parameter name='isSalesKit' type='System.Boolean'

><![CDATA[]]></parameter>

<parameter name='isPhantom' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>ChangePartNum</methodName>
<returnType>void</returnType>
<localTime>3/18/2011 10:12:15:0378577 AM</localTime>
<executionTime>687.126</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote
<http://www.epicor.com/Mfg/100/BO.Quote/Quote> " /></parameter>
<parameter name='uomCode' type='System.String'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>Update</methodName>
<returnType>void</returnType>
<localTime>3/18/2011 10:12:15:7874497 AM</localTime>
<executionTime>1686.582</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote
<http://www.epicor.com/Mfg/100/BO.Quote/Quote> " /></parameter>
</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.TaskSet</businessObject>
<methodName>GetCRMTaskSetList</methodName>
<returnType>Epicor.Mfg.BO.TaskSetListDataSet</returnType>
<localTime>3/18/2011 10:12:17:6458132 AM</localTime>
<executionTime>31.233</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='taskSetId' type='System.String'

><![CDATA[DEF]]></parameter>

<parameter name='activeTaskId' type='System.String'

><![CDATA[DEF]]></parameter>

<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Task</businessObject>
<methodName>GetRows</methodName>
<returnType>Epicor.Mfg.BO.TaskDataSet</returnType>
<localTime>3/18/2011 10:12:17:6926627 AM</localTime>
<executionTime>203.0145</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClauseTask' type='System.String' ><![CDATA[Key1 =
'1759' AND RelatedToFile = 'QuoteHed']]></parameter>
<parameter name='whereClauseTaskCnt' type='System.String'

><![CDATA[]]></parameter>

<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.TaskSet</businessObject>
<methodName>GetByID</methodName>
<returnType>Epicor.Mfg.BO.TaskSetDataSet</returnType>
<localTime>3/18/2011 10:12:17:8956772 AM</localTime>
<executionTime>93.699</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='taskSetID' type='System.String'

><![CDATA[DEF]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.QuoteAsm</businessObject>
<methodName>GetDatasetForTree</methodName>
<returnType>Epicor.Mfg.BO.QuoteAsmDataSet</returnType>
<localTime>3/18/2011 10:12:18:0049927 AM</localTime>
<executionTime>187.398</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='ipQuoteNum' type='System.Int32'

><![CDATA[1759]]></parameter>

<parameter name='ipQuoteLine' type='System.Int32'

><![CDATA[1]]></parameter>

<parameter name='ipStartAssemblySeq' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='ipCurrentAssemblySeq' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='ipCompleteTree' type='System.Boolean'

><![CDATA[False]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>GetByID</methodName>
<returnType>Epicor.Mfg.BO.QuoteDataSet</returnType>
<localTime>3/18/2011 10:12:18:2548567 AM</localTime>
<executionTime>8183.046</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='quoteNum' type='System.Int32'

><![CDATA[1759]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>GetDtlUnitPriceInfo</methodName>
<returnType>void</returnType>
<localTime>3/18/2011 10:12:31:4820322 AM</localTime>
<executionTime>406.029</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='skipDiscLookup' type='System.Boolean'

><![CDATA[False]]></parameter>

<parameter name='preserveAmt' type='System.Boolean'

><![CDATA[False]]></parameter>

<parameter name='changedColumn' type='System.String'

><![CDATA[SellingExpectedQty]]></parameter>

<parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote
<http://www.epicor.com/Mfg/100/BO.Quote/Quote> " /></parameter>
</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>Update</methodName>
<returnType>void</returnType>
<localTime>3/18/2011 10:12:36:5417782 AM</localTime>
<executionTime>936.99</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote
<http://www.epicor.com/Mfg/100/BO.Quote/Quote> " /></parameter>
</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.TaskSet</businessObject>
<methodName>GetCRMTaskSetList</methodName>
<returnType>Epicor.Mfg.BO.TaskSetListDataSet</returnType>
<localTime>3/18/2011 10:12:37:6349332 AM</localTime>
<executionTime>46.8495</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='taskSetId' type='System.String'

><![CDATA[DEF]]></parameter>

<parameter name='activeTaskId' type='System.String'

><![CDATA[DEF]]></parameter>

<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Task</businessObject>
<methodName>GetRows</methodName>
<returnType>Epicor.Mfg.BO.TaskDataSet</returnType>
<localTime>3/18/2011 10:12:37:6817827 AM</localTime>
<executionTime>218.631</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClauseTask' type='System.String' ><![CDATA[Key1 =
'1759' AND RelatedToFile = 'QuoteHed']]></parameter>
<parameter name='whereClauseTaskCnt' type='System.String'

><![CDATA[]]></parameter>

<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.TaskSet</businessObject>
<methodName>GetByID</methodName>
<returnType>Epicor.Mfg.BO.TaskSetDataSet</returnType>
<localTime>3/18/2011 10:12:37:9004137 AM</localTime>
<executionTime>78.0825</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='taskSetID' type='System.String'

><![CDATA[DEF]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.QuoteAsm</businessObject>
<methodName>GetDatasetForTree</methodName>
<returnType>Epicor.Mfg.BO.QuoteAsmDataSet</returnType>
<localTime>3/18/2011 10:12:38:0097292 AM</localTime>
<executionTime>140.5485</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='ipQuoteNum' type='System.Int32'

><![CDATA[1759]]></parameter>

<parameter name='ipQuoteLine' type='System.Int32'

><![CDATA[1]]></parameter>

<parameter name='ipStartAssemblySeq' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='ipCurrentAssemblySeq' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='ipCompleteTree' type='System.Boolean'

><![CDATA[False]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
<methodName>GetRowsKeepIdleTime</methodName>
<returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
<localTime>3/18/2011 10:12:41:6796067 AM</localTime>
<executionTime>31.233</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClauseSysRptLst' type='System.String'

><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction

<> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>Update</methodName>
<returnType>void</returnType>
<localTime>3/18/2011 10:13:03:2772262 AM</localTime>
<executionTime>515.3445</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote
<http://www.epicor.com/Mfg/100/BO.Quote/Quote> " /></parameter>
</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
<methodName>GetRowsKeepIdleTime</methodName>
<returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
<localTime>3/18/2011 10:13:11:6945197 AM</localTime>
<executionTime>46.8495</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClauseSysRptLst' type='System.String'

><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction

<> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
<methodName>GetRowsKeepIdleTime</methodName>
<returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
<localTime>3/18/2011 10:13:41:7406657 AM</localTime>
<executionTime>31.233</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClauseSysRptLst' type='System.String'

><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction

<> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
<methodName>GetRowsKeepIdleTime</methodName>
<returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
<localTime>3/18/2011 10:14:11:7749422 AM</localTime>
<executionTime>46.8585</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClauseSysRptLst' type='System.String'

><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction

<> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.SalesTer</businessObject>
<methodName>GetListPlusRO</methodName>
<returnType>Epicor.Mfg.BO.SalesTerListDataSet</returnType>
<localTime>3/18/2011 10:14:29:8310842 AM</localTime>
<executionTime>78.0975</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClause' type='System.String'

><![CDATA[]]></parameter>

<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.EpiSearch</businessObject>
<methodName>DoNamedSearch</methodName>
<returnType>Epicor.Mfg.BO.NamedSearchDataSet</returnType>
<localTime>3/18/2011 10:14:29:9248012 AM</localTime>
<executionTime>31.239</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='nswNamedSearch' type='System.String'

><![CDATA[ProductID = 'EP' AND SearchForm = 'Opportunity / Quote Search'

AND CalledFrom = 'Epicor.Mfg.UI.QuoteEntry.dll' AND DcdUserID =
'Len']]></parameter>
<parameter name='nswControlSetting' type='System.String'

><![CDATA[]]></parameter>

<parameter name='nswWhereClause' type='System.String'

><![CDATA[]]></parameter>

<parameter name='ds' type='Epicor.Mfg.BO.DashBdDefListDataSet'

><DashBdDefListDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList
<http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList> "
/></parameter>
<parameter name='pcProdID' type='System.String'

><![CDATA[]]></parameter>

<parameter name='pcLike' type='System.String' ><![CDATA[]]></parameter>
<parameter name='ds1' type='Epicor.Mfg.BO.DynamicQueryListDataSet'

><DynamicQueryListDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList
<http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList> "
/></parameter>
<parameter name='piPage' type='System.Int32' ><![CDATA[0]]></parameter>
<parameter name='piAbsolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='pbMore' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.QuickSearch</businessObject>
<methodName>GetBaseDefault</methodName>
<returnType>void</returnType>
<localTime>3/18/2011 10:14:29:9716597 AM</localTime>
<executionTime>15.6195</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='pcLikeField' type='System.String'

><![CDATA[QuoteHed.QuoteNum]]></parameter>

<parameter name='pcCallFrom' type='System.String'

><![CDATA[Epicor.Mfg.UI.QuoteEntry]]></parameter>

<parameter name='pcBaseSearchID' type='System.String'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.QuickSearch</businessObject>
<methodName>GetLikeFieldSearches</methodName>
<returnType>Epicor.Mfg.BO.QuickSearchListDataSet</returnType>
<localTime>3/18/2011 10:14:31:5336097 AM</localTime>
<executionTime>31.239</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='pcLikeField' type='System.String'

><![CDATA[QuoteHed.QuoteNum]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.DynamicQuery</businessObject>
<methodName>GetListFromLike</methodName>
<returnType>Epicor.Mfg.BO.DynamicQueryListDataSet</returnType>
<localTime>3/18/2011 10:14:33:7203397 AM</localTime>
<executionTime>62.478</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='pcLikeTable' type='System.String'

><![CDATA[QuoteHed]]></parameter>

<parameter name='pcLikeField' type='System.String'

><![CDATA[QuoteNum]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
<methodName>GetRowsKeepIdleTime</methodName>
<returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
<localTime>3/18/2011 10:14:41:8112407 AM</localTime>
<executionTime>31.239</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClauseSysRptLst' type='System.String'

><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction

<> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.QuickSearch</businessObject>
<methodName>GetByID</methodName>
<returnType>Epicor.Mfg.BO.QuickSearchDataSet</returnType>
<localTime>3/18/2011 10:14:55:0253377 AM</localTime>
<executionTime>109.3365</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='glbCompany' type='System.String'

><![CDATA[]]></parameter>

<parameter name='quickSearchID' type='System.String'

><![CDATA[QuoteCost]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.Lib.ClassAttribute</businessObject>
<methodName>GetAttributes</methodName>
<returnType>Epicor.Mfg.Lib.ClassAttributeDataSet</returnType>
<localTime>3/18/2011 10:14:55:1346742 AM</localTime>
<executionTime>156.195</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='classNames' type='System.String'

><![CDATA[QuickSearch]]></parameter>

<parameter name='nameSpace' type='System.String'

><![CDATA[Epicor.Mfg.BO]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.EpiSearch</businessObject>
<methodName>DoNamedSearch</methodName>
<returnType>Epicor.Mfg.BO.NamedSearchDataSet</returnType>
<localTime>3/18/2011 10:14:55:3377277 AM</localTime>
<executionTime>31.239</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='nswNamedSearch' type='System.String'

><![CDATA[ProductID = 'EP' AND SearchForm = 'Search Form' AND CalledFrom

= 'Epicor.Mfg.UI.QuoteEntry.dll' AND DcdUserID = 'Len']]></parameter>
<parameter name='nswControlSetting' type='System.String'

><![CDATA[]]></parameter>

<parameter name='nswWhereClause' type='System.String'

><![CDATA[]]></parameter>

<parameter name='ds' type='Epicor.Mfg.BO.DashBdDefListDataSet'

><DashBdDefListDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList
<http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList> "
/></parameter>
<parameter name='pcProdID' type='System.String'

><![CDATA[]]></parameter>

<parameter name='pcLike' type='System.String' ><![CDATA[]]></parameter>
<parameter name='ds1' type='Epicor.Mfg.BO.DynamicQueryListDataSet'

><DynamicQueryListDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList
<http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList> "
/></parameter>
<parameter name='piPage' type='System.Int32' ><![CDATA[0]]></parameter>
<parameter name='piAbsolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='pbMore' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.SalesTer</businessObject>
<methodName>GetListPlusRO</methodName>
<returnType>Epicor.Mfg.BO.SalesTerListDataSet</returnType>
<localTime>3/18/2011 10:14:57:9461842 AM</localTime>
<executionTime>78.0975</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClause' type='System.String'

><![CDATA[]]></parameter>

<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.EpiSearch</businessObject>
<methodName>DoNamedSearch</methodName>
<returnType>Epicor.Mfg.BO.NamedSearchDataSet</returnType>
<localTime>3/18/2011 10:14:58:0399012 AM</localTime>
<executionTime>46.8585</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='nswNamedSearch' type='System.String'

><![CDATA[ProductID = 'EP' AND SearchForm = 'Opportunity / Quote Search'

AND CalledFrom = 'Epicor.Mfg.UI.QuoteEntry.QuickSearch.QuoteCost.dll'
AND DcdUserID = 'Len']]></parameter>
<parameter name='nswControlSetting' type='System.String'

><![CDATA[]]></parameter>

<parameter name='nswWhereClause' type='System.String'

><![CDATA[]]></parameter>

<parameter name='ds' type='Epicor.Mfg.BO.DashBdDefListDataSet'

><DashBdDefListDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList
<http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList> "
/></parameter>
<parameter name='pcProdID' type='System.String'

><![CDATA[]]></parameter>

<parameter name='pcLike' type='System.String' ><![CDATA[]]></parameter>
<parameter name='ds1' type='Epicor.Mfg.BO.DynamicQueryListDataSet'

><DynamicQueryListDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList
<http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList> "
/></parameter>
<parameter name='piPage' type='System.Int32' ><![CDATA[0]]></parameter>
<parameter name='piAbsolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='pbMore' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.QuickSearch</businessObject>
<methodName>GetBaseDefault</methodName>
<returnType>void</returnType>
<localTime>3/18/2011 10:14:58:0867597 AM</localTime>
<executionTime>31.239</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='pcLikeField' type='System.String'

><![CDATA[QuoteHed.QuoteNum]]></parameter>

<parameter name='pcCallFrom' type='System.String'

><![CDATA[Epicor.Mfg.UI.QuoteEntry.QuickSearch.QuoteCost]]></parameter>

<parameter name='pcBaseSearchID' type='System.String'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>GetList</methodName>
<returnType>Epicor.Mfg.BO.QuoteHedListDataSet</returnType>
<localTime>3/18/2011 10:15:03:6316822 AM</localTime>
<executionTime>218.673</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClause' type='System.String' ><![CDATA[QuoteNum

>= '1747' BY QuoteNum DESC]]></parameter>

<parameter name='pageSize' type='System.Int32'

><![CDATA[100]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
<methodName>GetRowsKeepIdleTime</methodName>
<returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
<localTime>3/18/2011 10:15:11:8319197 AM</localTime>
<executionTime>31.239</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClauseSysRptLst' type='System.String'

><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction

<> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>GetList</methodName>
<returnType>Epicor.Mfg.BO.QuoteHedListDataSet</returnType>
<localTime>3/18/2011 10:15:20:6569372 AM</localTime>
<executionTime>687.258</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClause' type='System.String' ><![CDATA[QuoteNum

>= '1700' BY QuoteNum DESC]]></parameter>

<parameter name='pageSize' type='System.Int32'

><![CDATA[100]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>

<tracePacket>
<businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
<methodName>GetRowsKeepIdleTime</methodName>
<returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
<localTime>3/18/2011 10:15:41:8525987 AM</localTime>
<executionTime>31.239</executionTime>
<parameters>
<parameter name='cc'
type='Epicor.Mfg.Core.CallContext.CallContextDataSet'

><CallContextDataSet

xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
<http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
/></parameter>
<parameter name='whereClauseSysRptLst' type='System.String'

><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction

<> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
<parameter name='pageSize' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='absolutePage' type='System.Int32'

><![CDATA[0]]></parameter>

<parameter name='morePages' type='System.Boolean'

><![CDATA[]]></parameter>

</parameters>
</tracePacket>
************************************************************************
**** end

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mordechai
Sent: Thursday, March 17, 2011 2:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Request for simple speed test

Len,
if you want, I can run your system log through and analyzer
send me a zip file of your log
also, send me the tracing file for the quote transaction
thanks
motty

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Len
Hartka" <len.hartka@...> wrote:

>
> Good Day:
>
> We continue to chase slowness in E9.
>
> Sun went live on 11/29/10
> on Epicor 9, 9.05.601B SQL-Unidata
> Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
>
> One specific item is: In Quote entry, Line-Entry, After you type in
> the Part# and hit [Enter], it takes 15 seconds for the screen to

cycle.

> In Order-Entry it is only 2-4 seconds
>
> 1. Do have a similar delay on your system?
> 2. Version?
> 3. Progress, SQL, or SQL-Unidata
> 4. number of Part#s - we have 280,000
>
>
>
> len.hartka@...
> <blocked::mailto:len.hartka@...>
>
>
> **************************************************************
>
> Sun Automation Group
>
> Celebrating
>
> 25 Years of Service
>
> to the Corrugated Industry
>
> **************************************************************
>
>
>
>
> This e-mail and any attachments may contain proprietary and/or

confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

system · March 18, 2011, 11:33am

Blake, a Dump and Load does nothing to clean out any "Bad" data in the
Database, it does not affect data at all. The only thing a dump and load
does is to re-arrange the location of the data and put the data from all
tables together, closer to one another in order to make the accessing of the
data from the same table faster since it is more organize.

The data itself is not affected by the dump and load. Bad data is still bad
data.

One thing I have found useful is to use the D&L process as an opportunity to
flush tables like the Chglog table, which can speed things up considerably
since the DB as a whole is smaller up to 75% in some cases, but you do lose
your Change log Data up to that point. Although many people have Change Logs
setup and not even realize how much more data that is putting into the DB,
especially if it's change log data that you don't actually need.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Blake Clemens
Sent: Friday, March 18, 2011 9:39 AM
To: vantage@yahoogroups.com
Cc: len.hartka@...
Subject: RE: [Vantage] Request for simple speed test

Sure... "Dump & Load" is a procedure done to the Vantage database.
Through various steps you take the database and run it through some
processes that clean out all the "bad" data. You then restore the newly
"cleaned" up data. It typically makes your Vantage wait times a lot
shorter. For example, there is a certain canned Vantage financial report
that takes about 3 minutes to run after a dump and load. After about three
months after the dump and load that same report takes 40 minutes. That is
how I know its time to run a dump and load again.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Len Hartka
Sent: Friday, March 18, 2011 9:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Request for simple speed test

Good Day Blake:

I am not sure what you mean by "Dump and Load".

Could you explain a little.

Len

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Blake Clemens
Sent: Thursday, March 17, 2011 1:26 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Is your Quote Entry customized? Have you done a dump and load of the
database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in the
Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com> >

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or confidential
information. If you are not the intended recipient, please notify the sender
immediately by reply e-mail or at 410-472-2900 and then delete the message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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

This e-mail and any attachments may contain proprietary and/or confidential
information. If you are not the intended recipient, please notify the sender
immediately by reply e-mail or at 410-472-2900 and then delete the message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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

------------------------------------

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/linksYahoo! Groups Links

system · March 18, 2011, 11:40am

You are on SQL - Have you setup and populated the Full Text Catalogs for the
Database correctly?

You will see a jump in performance if you are able to get those setup. Same
goes for a whole bunch of other screens as well.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in the
Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@...
<blocked::mailto:len.hartka@...>

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or confidential
information. If you are not the intended recipient, please notify the sender
immediately by reply e-mail or at 410-472-2900 and then delete the message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

------------------------------------

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/linksYahoo! Groups Links

system · March 18, 2011, 12:34pm

God Day Ned and Blake:

Speed is the question.

We have a large db -- 18 gig.
We have 298,000 Part#'s

How long does D&L take?
How long did your data download take - ours took 50 hours with
continuously running 8 processors.

len.hartka@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned
Sent: Friday, March 18, 2011 11:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Request for simple speed test

Blake, a Dump and Load does nothing to clean out any "Bad" data in the
Database, it does not affect data at all. The only thing a dump and load
does is to re-arrange the location of the data and put the data from all
tables together, closer to one another in order to make the accessing of
the
data from the same table faster since it is more organize.

The data itself is not affected by the dump and load. Bad data is still
bad
data.

One thing I have found useful is to use the D&L process as an
opportunity to
flush tables like the Chglog table, which can speed things up
considerably
since the DB as a whole is smaller up to 75% in some cases, but you do
lose
your Change log Data up to that point. Although many people have Change
Logs
setup and not even realize how much more data that is putting into the
DB,
especially if it's change log data that you don't actually need.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Friday, March 18, 2011 9:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Cc: len.hartka@... <mailto:len.hartka%40sunautomation.com>

Subject: RE: [Vantage] Request for simple speed test

Sure... "Dump & Load" is a procedure done to the Vantage database.
Through various steps you take the database and run it through some
processes that clean out all the "bad" data. You then restore the newly
"cleaned" up data. It typically makes your Vantage wait times a lot
shorter. For example, there is a certain canned Vantage financial report
that takes about 3 minutes to run after a dump and load. After about
three
months after the dump and load that same report takes 40 minutes. That
is
how I know its time to run a dump and load again.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Len Hartka
Sent: Friday, March 18, 2011 9:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Good Day Blake:

I am not sure what you mean by "Dump and Load".

Could you explain a little.

Len

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Blake Clemens
Sent: Thursday, March 17, 2011 1:26 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Is your Quote Entry customized? Have you done a dump and load of the
database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in the
Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com> >

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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

------------------------------------

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/linksYahoo! Groups Links

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

system · March 18, 2011, 12:46pm

email the files to mseal@... - I can't copy this with the extra lines
and yes, the server logs
thanks
motty

--- In vantage@yahoogroups.com, "Len Hartka" <len.hartka@...> wrote:
>
> Good Day Motty:
>
> 1. "Zip of log file". Which log? which server?
>
> 2. Below is the trace for Quote # 1759, Part# ( ---010544--). Cust#
> Le0979
> Started with clicking "add-new-line" ended with adding quantity,
> then save.
>
>
> len.hartka@...
>
> ****************************************************************
> begin
> cket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>GetNewQuoteDtl</methodName>
> <returnType>void</returnType>
> <localTime>3/18/2011 10:11:55:1580532 AM</localTime>
> <executionTime>671.5095</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet"
> /></parameter>
> <parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote" /></parameter>
> <parameter name='quoteNum' type='System.Int32'
> ><![CDATA[1759]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
> <methodName>GetRowsKeepIdleTime</methodName>
> <returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
> <localTime>3/18/2011 10:12:11:6334607 AM</localTime>
> <executionTime>62.466</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClauseSysRptLst' type='System.String'
> ><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction
> <> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>GetPartXRefInfo</methodName>
> <returnType>void</returnType>
> <localTime>3/18/2011 10:12:14:6162122 AM</localTime>
> <executionTime>109.3155</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='partNum' type='System.String'
> ><![CDATA[---010544--]]></parameter>
> <parameter name='sysRowID' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='rowType' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='uomCode' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='serialWarning' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='questionString' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='multipleMatch' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>CheckPrePartInfo</methodName>
> <returnType>void</returnType>
> <localTime>3/18/2011 10:12:14:7255277 AM</localTime>
> <executionTime>234.2475</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='quoteNum' type='System.Int32'
> ><![CDATA[1759]]></parameter>
> <parameter name='quoteLine' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='fieldName' type='System.String'
> ><![CDATA[PartNum]]></parameter>
> <parameter name='partNum' type='System.String'
> ><![CDATA[---010544--]]></parameter>
> <parameter name='vMessage' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='vBMessage' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='vPMessage' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='vSubAvail' type='System.Boolean'
> ><![CDATA[]]></parameter>
> <parameter name='vMsgType' type='System.String'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Part</businessObject>
> <methodName>PartIsSalesKit</methodName>
> <returnType>bool</returnType>
> <localTime>3/18/2011 10:12:14:9597752 AM</localTime>
> <executionTime>78.0825</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='partNumber' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='isSalesKit' type='System.Boolean'
> ><![CDATA[]]></parameter>
> <parameter name='isPhantom' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>ChangePartNum</methodName>
> <returnType>void</returnType>
> <localTime>3/18/2011 10:12:15:0378577 AM</localTime>
> <executionTime>687.126</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote
> <http://www.epicor.com/Mfg/100/BO.Quote/Quote> " /></parameter>
> <parameter name='uomCode' type='System.String'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>Update</methodName>
> <returnType>void</returnType>
> <localTime>3/18/2011 10:12:15:7874497 AM</localTime>
> <executionTime>1686.582</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote
> <http://www.epicor.com/Mfg/100/BO.Quote/Quote> " /></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.TaskSet</businessObject>
> <methodName>GetCRMTaskSetList</methodName>
> <returnType>Epicor.Mfg.BO.TaskSetListDataSet</returnType>
> <localTime>3/18/2011 10:12:17:6458132 AM</localTime>
> <executionTime>31.233</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='taskSetId' type='System.String'
> ><![CDATA[DEF]]></parameter>
> <parameter name='activeTaskId' type='System.String'
> ><![CDATA[DEF]]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Task</businessObject>
> <methodName>GetRows</methodName>
> <returnType>Epicor.Mfg.BO.TaskDataSet</returnType>
> <localTime>3/18/2011 10:12:17:6926627 AM</localTime>
> <executionTime>203.0145</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClauseTask' type='System.String' ><![CDATA[Key1 =
> '1759' AND RelatedToFile = 'QuoteHed']]></parameter>
> <parameter name='whereClauseTaskCnt' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.TaskSet</businessObject>
> <methodName>GetByID</methodName>
> <returnType>Epicor.Mfg.BO.TaskSetDataSet</returnType>
> <localTime>3/18/2011 10:12:17:8956772 AM</localTime>
> <executionTime>93.699</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='taskSetID' type='System.String'
> ><![CDATA[DEF]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.QuoteAsm</businessObject>
> <methodName>GetDatasetForTree</methodName>
> <returnType>Epicor.Mfg.BO.QuoteAsmDataSet</returnType>
> <localTime>3/18/2011 10:12:18:0049927 AM</localTime>
> <executionTime>187.398</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='ipQuoteNum' type='System.Int32'
> ><![CDATA[1759]]></parameter>
> <parameter name='ipQuoteLine' type='System.Int32'
> ><![CDATA[1]]></parameter>
> <parameter name='ipStartAssemblySeq' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='ipCurrentAssemblySeq' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='ipCompleteTree' type='System.Boolean'
> ><![CDATA[False]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>GetByID</methodName>
> <returnType>Epicor.Mfg.BO.QuoteDataSet</returnType>
> <localTime>3/18/2011 10:12:18:2548567 AM</localTime>
> <executionTime>8183.046</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='quoteNum' type='System.Int32'
> ><![CDATA[1759]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>GetDtlUnitPriceInfo</methodName>
> <returnType>void</returnType>
> <localTime>3/18/2011 10:12:31:4820322 AM</localTime>
> <executionTime>406.029</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='skipDiscLookup' type='System.Boolean'
> ><![CDATA[False]]></parameter>
> <parameter name='preserveAmt' type='System.Boolean'
> ><![CDATA[False]]></parameter>
> <parameter name='changedColumn' type='System.String'
> ><![CDATA[SellingExpectedQty]]></parameter>
> <parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote
> <http://www.epicor.com/Mfg/100/BO.Quote/Quote> " /></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>Update</methodName>
> <returnType>void</returnType>
> <localTime>3/18/2011 10:12:36:5417782 AM</localTime>
> <executionTime>936.99</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote
> <http://www.epicor.com/Mfg/100/BO.Quote/Quote> " /></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.TaskSet</businessObject>
> <methodName>GetCRMTaskSetList</methodName>
> <returnType>Epicor.Mfg.BO.TaskSetListDataSet</returnType>
> <localTime>3/18/2011 10:12:37:6349332 AM</localTime>
> <executionTime>46.8495</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='taskSetId' type='System.String'
> ><![CDATA[DEF]]></parameter>
> <parameter name='activeTaskId' type='System.String'
> ><![CDATA[DEF]]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Task</businessObject>
> <methodName>GetRows</methodName>
> <returnType>Epicor.Mfg.BO.TaskDataSet</returnType>
> <localTime>3/18/2011 10:12:37:6817827 AM</localTime>
> <executionTime>218.631</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClauseTask' type='System.String' ><![CDATA[Key1 =
> '1759' AND RelatedToFile = 'QuoteHed']]></parameter>
> <parameter name='whereClauseTaskCnt' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.TaskSet</businessObject>
> <methodName>GetByID</methodName>
> <returnType>Epicor.Mfg.BO.TaskSetDataSet</returnType>
> <localTime>3/18/2011 10:12:37:9004137 AM</localTime>
> <executionTime>78.0825</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='taskSetID' type='System.String'
> ><![CDATA[DEF]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.QuoteAsm</businessObject>
> <methodName>GetDatasetForTree</methodName>
> <returnType>Epicor.Mfg.BO.QuoteAsmDataSet</returnType>
> <localTime>3/18/2011 10:12:38:0097292 AM</localTime>
> <executionTime>140.5485</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='ipQuoteNum' type='System.Int32'
> ><![CDATA[1759]]></parameter>
> <parameter name='ipQuoteLine' type='System.Int32'
> ><![CDATA[1]]></parameter>
> <parameter name='ipStartAssemblySeq' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='ipCurrentAssemblySeq' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='ipCompleteTree' type='System.Boolean'
> ><![CDATA[False]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
> <methodName>GetRowsKeepIdleTime</methodName>
> <returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
> <localTime>3/18/2011 10:12:41:6796067 AM</localTime>
> <executionTime>31.233</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClauseSysRptLst' type='System.String'
> ><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction
> <> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>Update</methodName>
> <returnType>void</returnType>
> <localTime>3/18/2011 10:13:03:2772262 AM</localTime>
> <executionTime>515.3445</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote
> <http://www.epicor.com/Mfg/100/BO.Quote/Quote> " /></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
> <methodName>GetRowsKeepIdleTime</methodName>
> <returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
> <localTime>3/18/2011 10:13:11:6945197 AM</localTime>
> <executionTime>46.8495</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClauseSysRptLst' type='System.String'
> ><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction
> <> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
> <methodName>GetRowsKeepIdleTime</methodName>
> <returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
> <localTime>3/18/2011 10:13:41:7406657 AM</localTime>
> <executionTime>31.233</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClauseSysRptLst' type='System.String'
> ><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction
> <> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
> <methodName>GetRowsKeepIdleTime</methodName>
> <returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
> <localTime>3/18/2011 10:14:11:7749422 AM</localTime>
> <executionTime>46.8585</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClauseSysRptLst' type='System.String'
> ><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction
> <> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.SalesTer</businessObject>
> <methodName>GetListPlusRO</methodName>
> <returnType>Epicor.Mfg.BO.SalesTerListDataSet</returnType>
> <localTime>3/18/2011 10:14:29:8310842 AM</localTime>
> <executionTime>78.0975</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClause' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.EpiSearch</businessObject>
> <methodName>DoNamedSearch</methodName>
> <returnType>Epicor.Mfg.BO.NamedSearchDataSet</returnType>
> <localTime>3/18/2011 10:14:29:9248012 AM</localTime>
> <executionTime>31.239</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='nswNamedSearch' type='System.String'
> ><![CDATA[ProductID = 'EP' AND SearchForm = 'Opportunity / Quote Search'
> AND CalledFrom = 'Epicor.Mfg.UI.QuoteEntry.dll' AND DcdUserID =
> 'Len']]></parameter>
> <parameter name='nswControlSetting' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='nswWhereClause' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='ds' type='Epicor.Mfg.BO.DashBdDefListDataSet'
> ><DashBdDefListDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList
> <http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList> "
> /></parameter>
> <parameter name='pcProdID' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='pcLike' type='System.String' ><![CDATA[]]></parameter>
> <parameter name='ds1' type='Epicor.Mfg.BO.DynamicQueryListDataSet'
> ><DynamicQueryListDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList
> <http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList> "
> /></parameter>
> <parameter name='piPage' type='System.Int32' ><![CDATA[0]]></parameter>
> <parameter name='piAbsolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='pbMore' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.QuickSearch</businessObject>
> <methodName>GetBaseDefault</methodName>
> <returnType>void</returnType>
> <localTime>3/18/2011 10:14:29:9716597 AM</localTime>
> <executionTime>15.6195</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='pcLikeField' type='System.String'
> ><![CDATA[QuoteHed.QuoteNum]]></parameter>
> <parameter name='pcCallFrom' type='System.String'
> ><![CDATA[Epicor.Mfg.UI.QuoteEntry]]></parameter>
> <parameter name='pcBaseSearchID' type='System.String'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.QuickSearch</businessObject>
> <methodName>GetLikeFieldSearches</methodName>
> <returnType>Epicor.Mfg.BO.QuickSearchListDataSet</returnType>
> <localTime>3/18/2011 10:14:31:5336097 AM</localTime>
> <executionTime>31.239</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='pcLikeField' type='System.String'
> ><![CDATA[QuoteHed.QuoteNum]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.DynamicQuery</businessObject>
> <methodName>GetListFromLike</methodName>
> <returnType>Epicor.Mfg.BO.DynamicQueryListDataSet</returnType>
> <localTime>3/18/2011 10:14:33:7203397 AM</localTime>
> <executionTime>62.478</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='pcLikeTable' type='System.String'
> ><![CDATA[QuoteHed]]></parameter>
> <parameter name='pcLikeField' type='System.String'
> ><![CDATA[QuoteNum]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
> <methodName>GetRowsKeepIdleTime</methodName>
> <returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
> <localTime>3/18/2011 10:14:41:8112407 AM</localTime>
> <executionTime>31.239</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClauseSysRptLst' type='System.String'
> ><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction
> <> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.QuickSearch</businessObject>
> <methodName>GetByID</methodName>
> <returnType>Epicor.Mfg.BO.QuickSearchDataSet</returnType>
> <localTime>3/18/2011 10:14:55:0253377 AM</localTime>
> <executionTime>109.3365</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='glbCompany' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='quickSearchID' type='System.String'
> ><![CDATA[QuoteCost]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.Lib.ClassAttribute</businessObject>
> <methodName>GetAttributes</methodName>
> <returnType>Epicor.Mfg.Lib.ClassAttributeDataSet</returnType>
> <localTime>3/18/2011 10:14:55:1346742 AM</localTime>
> <executionTime>156.195</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='classNames' type='System.String'
> ><![CDATA[QuickSearch]]></parameter>
> <parameter name='nameSpace' type='System.String'
> ><![CDATA[Epicor.Mfg.BO]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.EpiSearch</businessObject>
> <methodName>DoNamedSearch</methodName>
> <returnType>Epicor.Mfg.BO.NamedSearchDataSet</returnType>
> <localTime>3/18/2011 10:14:55:3377277 AM</localTime>
> <executionTime>31.239</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='nswNamedSearch' type='System.String'
> ><![CDATA[ProductID = 'EP' AND SearchForm = 'Search Form' AND CalledFrom
> = 'Epicor.Mfg.UI.QuoteEntry.dll' AND DcdUserID = 'Len']]></parameter>
> <parameter name='nswControlSetting' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='nswWhereClause' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='ds' type='Epicor.Mfg.BO.DashBdDefListDataSet'
> ><DashBdDefListDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList
> <http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList> "
> /></parameter>
> <parameter name='pcProdID' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='pcLike' type='System.String' ><![CDATA[]]></parameter>
> <parameter name='ds1' type='Epicor.Mfg.BO.DynamicQueryListDataSet'
> ><DynamicQueryListDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList
> <http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList> "
> /></parameter>
> <parameter name='piPage' type='System.Int32' ><![CDATA[0]]></parameter>
> <parameter name='piAbsolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='pbMore' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.SalesTer</businessObject>
> <methodName>GetListPlusRO</methodName>
> <returnType>Epicor.Mfg.BO.SalesTerListDataSet</returnType>
> <localTime>3/18/2011 10:14:57:9461842 AM</localTime>
> <executionTime>78.0975</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClause' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.EpiSearch</businessObject>
> <methodName>DoNamedSearch</methodName>
> <returnType>Epicor.Mfg.BO.NamedSearchDataSet</returnType>
> <localTime>3/18/2011 10:14:58:0399012 AM</localTime>
> <executionTime>46.8585</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='nswNamedSearch' type='System.String'
> ><![CDATA[ProductID = 'EP' AND SearchForm = 'Opportunity / Quote Search'
> AND CalledFrom = 'Epicor.Mfg.UI.QuoteEntry.QuickSearch.QuoteCost.dll'
> AND DcdUserID = 'Len']]></parameter>
> <parameter name='nswControlSetting' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='nswWhereClause' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='ds' type='Epicor.Mfg.BO.DashBdDefListDataSet'
> ><DashBdDefListDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList
> <http://www.epicor.com/Mfg/100/BO.EpiSearch/DashBdDefList> "
> /></parameter>
> <parameter name='pcProdID' type='System.String'
> ><![CDATA[]]></parameter>
> <parameter name='pcLike' type='System.String' ><![CDATA[]]></parameter>
> <parameter name='ds1' type='Epicor.Mfg.BO.DynamicQueryListDataSet'
> ><DynamicQueryListDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList
> <http://www.epicor.com/Mfg/100/BO.EpiSearch/DynamicQueryList> "
> /></parameter>
> <parameter name='piPage' type='System.Int32' ><![CDATA[0]]></parameter>
> <parameter name='piAbsolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='pbMore' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.QuickSearch</businessObject>
> <methodName>GetBaseDefault</methodName>
> <returnType>void</returnType>
> <localTime>3/18/2011 10:14:58:0867597 AM</localTime>
> <executionTime>31.239</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='pcLikeField' type='System.String'
> ><![CDATA[QuoteHed.QuoteNum]]></parameter>
> <parameter name='pcCallFrom' type='System.String'
> ><![CDATA[Epicor.Mfg.UI.QuoteEntry.QuickSearch.QuoteCost]]></parameter>
> <parameter name='pcBaseSearchID' type='System.String'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>GetList</methodName>
> <returnType>Epicor.Mfg.BO.QuoteHedListDataSet</returnType>
> <localTime>3/18/2011 10:15:03:6316822 AM</localTime>
> <executionTime>218.673</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClause' type='System.String' ><![CDATA[QuoteNum
> >= '1747' BY QuoteNum DESC]]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[100]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
> <methodName>GetRowsKeepIdleTime</methodName>
> <returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
> <localTime>3/18/2011 10:15:11:8319197 AM</localTime>
> <executionTime>31.239</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClauseSysRptLst' type='System.String'
> ><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction
> <> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>GetList</methodName>
> <returnType>Epicor.Mfg.BO.QuoteHedListDataSet</returnType>
> <localTime>3/18/2011 10:15:20:6569372 AM</localTime>
> <executionTime>687.258</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClause' type='System.String' ><![CDATA[QuoteNum
> >= '1700' BY QuoteNum DESC]]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[100]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
>
>
> <tracePacket>
> <businessObject>Epicor.Mfg.BO.ReportMonitor</businessObject>
> <methodName>GetRowsKeepIdleTime</methodName>
> <returnType>Epicor.Mfg.BO.ReportMonitorDataSet</returnType>
> <localTime>3/18/2011 10:15:41:8525987 AM</localTime>
> <executionTime>31.239</executionTime>
> <parameters>
> <parameter name='cc'
> type='Epicor.Mfg.Core.CallContext.CallContextDataSet'
> ><CallContextDataSet
> xmlns="http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet
> <http://www.epicor.com/Mfg/100/BO.CallContext/CallContextDataSet> "
> /></parameter>
> <parameter name='whereClauseSysRptLst' type='System.String'
> ><![CDATA[AutoAction <> '' AND AutoAction <> 'SSRSPrint' AND AutoAction
> <> 'SSRSPreview' AND WorkStationID ='66ITW01 0']]></parameter>
> <parameter name='pageSize' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='absolutePage' type='System.Int32'
> ><![CDATA[0]]></parameter>
> <parameter name='morePages' type='System.Boolean'
> ><![CDATA[]]></parameter>
> </parameters>
> </tracePacket>
> ************************************************************************
> **** end
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Mordechai
> Sent: Thursday, March 17, 2011 2:43 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Request for simple speed test
>
>
>
>
> Len,
> if you want, I can run your system log through and analyzer
> send me a zip file of your log
> also, send me the tracing file for the quote transaction
> thanks
> motty
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Len
> Hartka" <len.hartka@> wrote:
> >
> > Good Day:
> >
> > We continue to chase slowness in E9.
> >
> > Sun went live on 11/29/10
> > on Epicor 9, 9.05.601B SQL-Unidata
> > Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
> >
> > One specific item is: In Quote entry, Line-Entry, After you type in
> > the Part# and hit [Enter], it takes 15 seconds for the screen to
> cycle.
> > In Order-Entry it is only 2-4 seconds
> >
> > 1. Do have a similar delay on your system?
> > 2. Version?
> > 3. Progress, SQL, or SQL-Unidata
> > 4. number of Part#s - we have 280,000
> >
> >
> >
> > len.hartka@
> > <blocked::mailto:len.hartka@>
> >
> >
> > **************************************************************
> >
> > Sun Automation Group
> >
> > Celebrating
> >
> > 25 Years of Service
> >
> > to the Corrugated Industry
> >
> > **************************************************************
> >
> >
> >
> >
> > This e-mail and any attachments may contain proprietary and/or
> confidential information. If you are not the intended recipient, please
> notify the sender immediately by reply e-mail or at 410-472-2900 and
> then delete the message without using, disseminating, or copying this
> message or any portion thereof. With e-mail communications you are urged
> to protect against viruses.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
>
> [Non-text portions of this message have been removed]
>

system · March 18, 2011, 1:08pm

Our DB is 22GB

At first the Dump and Load process took me an entire weekend. I spent
the night here at work. But after the 3rd or 4th time I was able to get
that time down to about 12-16 hours. I now can perform it remotely. If
you worked on it straight through from start to finish I wouldn't be
surprised if it only took you 8-9 hours. What data download are you
speaking of?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Len Hartka
Sent: Friday, March 18, 2011 12:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Request for simple speed test

God Day Ned and Blake:

Speed is the question.

We have a large db -- 18 gig.
We have 298,000 Part#'s

How long does D&L take?
How long did your data download take - ours took 50 hours with
continuously running 8 processors.

len.hartka@... <mailto:len.hartka%40sunautomation.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ned
Sent: Friday, March 18, 2011 11:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Blake, a Dump and Load does nothing to clean out any "Bad" data in the
Database, it does not affect data at all. The only thing a dump and load
does is to re-arrange the location of the data and put the data from all
tables together, closer to one another in order to make the accessing of
the
data from the same table faster since it is more organize.

The data itself is not affected by the dump and load. Bad data is still
bad
data.

One thing I have found useful is to use the D&L process as an
opportunity to
flush tables like the Chglog table, which can speed things up
considerably
since the DB as a whole is smaller up to 75% in some cases, but you do
lose
your Change log Data up to that point. Although many people have Change
Logs
setup and not even realize how much more data that is putting into the
DB,
especially if it's change log data that you don't actually need.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Friday, March 18, 2011 9:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Cc: len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>

Subject: RE: [Vantage] Request for simple speed test

Sure... "Dump & Load" is a procedure done to the Vantage database.
Through various steps you take the database and run it through some
processes that clean out all the "bad" data. You then restore the newly
"cleaned" up data. It typically makes your Vantage wait times a lot
shorter. For example, there is a certain canned Vantage financial report
that takes about 3 minutes to run after a dump and load. After about
three
months after the dump and load that same report takes 40 minutes. That
is
how I know its time to run a dump and load again.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Len Hartka
Sent: Friday, March 18, 2011 9:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Good Day Blake:

I am not sure what you mean by "Dump and Load".

Could you explain a little.

Len

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Blake Clemens
Sent: Thursday, March 17, 2011 1:26 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Is your Quote Entry customized? Have you done a dump and load of the
database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in the
Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com> >

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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

------------------------------------

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/.
<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/linksYahoo! Groups Links

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

system · March 18, 2011, 1:21pm

Good Day Blake:

So you do it one file at a time? So you could do it over several
nights?

Our download was : The migration download, by Epicor, using the DMT
tool, and having broken up the files into 20,000 record files.sp 8
processors could be working on one file during the Migration. We
actually did a Passive-Active migration - "Fixed" data one weekend -
Active data 2 weeks later.

len.hartka@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Friday, March 18, 2011 1:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Request for simple speed test

Our DB is 22GB

At first the Dump and Load process took me an entire weekend. I spent
the night here at work. But after the 3rd or 4th time I was able to get
that time down to about 12-16 hours. I now can perform it remotely. If
you worked on it straight through from start to finish I wouldn't be
surprised if it only took you 8-9 hours. What data download are you
speaking of?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Friday, March 18, 2011 12:34 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

God Day Ned and Blake:

Speed is the question.

We have a large db -- 18 gig.
We have 298,000 Part#'s

How long does D&L take?
How long did your data download take - ours took 50 hours with
continuously running 8 processors.

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ned
Sent: Friday, March 18, 2011 11:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Blake, a Dump and Load does nothing to clean out any "Bad" data in the
Database, it does not affect data at all. The only thing a dump and load
does is to re-arrange the location of the data and put the data from all
tables together, closer to one another in order to make the accessing of
the
data from the same table faster since it is more organize.

The data itself is not affected by the dump and load. Bad data is still
bad
data.

One thing I have found useful is to use the D&L process as an
opportunity to
flush tables like the Chglog table, which can speed things up
considerably
since the DB as a whole is smaller up to 75% in some cases, but you do
lose
your Change log Data up to that point. Although many people have Change
Logs
setup and not even realize how much more data that is putting into the
DB,
especially if it's change log data that you don't actually need.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Friday, March 18, 2011 9:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Cc: len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>

Subject: RE: [Vantage] Request for simple speed test

Sure... "Dump & Load" is a procedure done to the Vantage database.
Through various steps you take the database and run it through some
processes that clean out all the "bad" data. You then restore the newly
"cleaned" up data. It typically makes your Vantage wait times a lot
shorter. For example, there is a certain canned Vantage financial report
that takes about 3 minutes to run after a dump and load. After about
three
months after the dump and load that same report takes 40 minutes. That
is
how I know its time to run a dump and load again.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Len Hartka
Sent: Friday, March 18, 2011 9:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Good Day Blake:

I am not sure what you mean by "Dump and Load".

Could you explain a little.

Len

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Blake Clemens
Sent: Thursday, March 17, 2011 1:26 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Is your Quote Entry customized? Have you done a dump and load of the
database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in the
Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com> >

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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

------------------------------------

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/.
<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/linksYahoo! Groups Links

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

system · March 18, 2011, 1:28pm

--- In vantage@yahoogroups.com, "Ned" <TechnoBabbly@...> wrote:

>
> One thing I have found useful is to use the D&L process as an opportunity to
> flush tables like the Chglog table, which can speed things up considerably
> since the DB as a whole is smaller up to 75% in some cases, but you do lose
> your Change log Data up to that point.

Ned:
What steps are you following to flush the ChgLog table? Are you deleting records between the Dump and Load stages? I have considered doing this but need to build up the confidence. Any precautions or suggestions? Thank you for any and all suggestions.

Peter Dunbar
Halm Industries Co., Inc.

system · March 18, 2011, 1:34pm

Ah, the migrations download.

Nope, do the whole thing at once. Follow the process from start to
finish.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Len Hartka
Sent: Friday, March 18, 2011 1:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Request for simple speed test

Good Day Blake:

So you do it one file at a time? So you could do it over several
nights?

Our download was : The migration download, by Epicor, using the DMT
tool, and having broken up the files into 20,000 record files.sp 8
processors could be working on one file during the Migration. We
actually did a Passive-Active migration - "Fixed" data one weekend -
Active data 2 weeks later.

len.hartka@... <mailto:len.hartka%40sunautomation.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Friday, March 18, 2011 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Our DB is 22GB

At first the Dump and Load process took me an entire weekend. I spent
the night here at work. But after the 3rd or 4th time I was able to get
that time down to about 12-16 hours. I now can perform it remotely. If
you worked on it straight through from start to finish I wouldn't be
surprised if it only took you 8-9 hours. What data download are you
speaking of?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Friday, March 18, 2011 12:34 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

God Day Ned and Blake:

Speed is the question.

We have a large db -- 18 gig.
We have 298,000 Part#'s

How long does D&L take?
How long did your data download take - ours took 50 hours with
continuously running 8 processors.

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ned
Sent: Friday, March 18, 2011 11:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Blake, a Dump and Load does nothing to clean out any "Bad" data in the
Database, it does not affect data at all. The only thing a dump and load
does is to re-arrange the location of the data and put the data from all
tables together, closer to one another in order to make the accessing of
the
data from the same table faster since it is more organize.

The data itself is not affected by the dump and load. Bad data is still
bad
data.

One thing I have found useful is to use the D&L process as an
opportunity to
flush tables like the Chglog table, which can speed things up
considerably
since the DB as a whole is smaller up to 75% in some cases, but you do
lose
your Change log Data up to that point. Although many people have Change
Logs
setup and not even realize how much more data that is putting into the
DB,
especially if it's change log data that you don't actually need.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Friday, March 18, 2011 9:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Cc: len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>

Subject: RE: [Vantage] Request for simple speed test

Sure... "Dump & Load" is a procedure done to the Vantage database.
Through various steps you take the database and run it through some
processes that clean out all the "bad" data. You then restore the newly
"cleaned" up data. It typically makes your Vantage wait times a lot
shorter. For example, there is a certain canned Vantage financial report
that takes about 3 minutes to run after a dump and load. After about
three
months after the dump and load that same report takes 40 minutes. That
is
how I know its time to run a dump and load again.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Len Hartka
Sent: Friday, March 18, 2011 9:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Good Day Blake:

I am not sure what you mean by "Dump and Load".

Could you explain a little.

Len

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Blake Clemens
Sent: Thursday, March 17, 2011 1:26 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Request for simple speed test

Is your Quote Entry customized? Have you done a dump and load of the
database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Len Hartka
Sent: Thursday, March 17, 2011 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for simple speed test

Good Day:

We continue to chase slowness in E9.

Sun went live on 11/29/10
on Epicor 9, 9.05.601B SQL-Unidata
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)

One specific item is: In Quote entry, Line-Entry, After you type in the
Part# and hit [Enter], it takes 15 seconds for the screen to cycle.
In Order-Entry it is only 2-4 seconds

1. Do have a similar delay on your system?
2. Version?
3. Progress, SQL, or SQL-Unidata
4. number of Part#s - we have 280,000

len.hartka@... <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<blocked::mailto:len.hartka@...
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com> >

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

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

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

------------------------------------

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/.
<http://groups.yahoo.com/group/vantage/files/>
<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/linksYahoo! Groups Links

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

Topic		Replies	Views
Database Purge and Summarize Yahoo Archive	7	2104	October 10, 2014
Our DB is now a Furth of what it used to be? Yahoo Archive	2	530	January 23, 2012
Purge? Blank Title 106702 Yahoo Archive	23	1665	January 17, 2012
New Test database Yahoo Archive	2	295	October 6, 2005
Progress database data purge Vista/Vantage 8 progress	3	903	May 7, 2020

Request for simple speed test/Change Log Housekeeping

Related Topics