Slow Opportunity/Quote Entry in 8.03.405A

Yahoo Archive
1
Progess does not have schema holders, it talks directly to the database. You may try and go through the tuning document Epicor has out there for 8.03.400..it has some pretty good knowledge on where and how to tune the database.

Jason Claggett
Microsoft Small Business Specialist
MCP #3856159
2W Technologies, LLC
312.533.4033 x8039
jason@...<mailto:jason@...>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Kerry_Muntz
Sent: Thursday, April 23, 2009 9:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Slow Opportunity/Quote Entry in 8.03.405A





We are on Progress. I take it Progress will probably have the equivalent option?
>
> We made things much better in .405 MSSQL by making our schema holder databases read-only.
>



[Non-text portions of this message have been removed]
2
Hi. Our quote team are extremely frustrated at the length of time it takes to do anything (add parts, delete parts, change operation details, saving). As I've read in other posts about other modules, Vantage gets more sluggish once 45 or more lines are in the quote.

It's taking 10-15 seconds to save the quote after altering a resource on an operation. This is with a 3GHz CPU (hyperthreading turned off), 2GB RAM, which appears to be in line with specs recommended in other posts. Similar times are reported for deleting materials, or dragging and dropping parts from other quotes.

(When a quote is small, and all is running well, 3-4 seconds is more normal... But many of our quotes are large, and segmenting them all is not an option.)

Any thoughts? Is this 'normal'? What can we try? Security settings?

What we are currently experimenting with is removing/disabling tabs etc that we don't use, which does seem promising. Anyone had success with this? Thanks.
3
We made things much better in .405 MSSQL by making our schema holder databases read-only.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Kerry_Muntz
Sent: Thursday, April 23, 2009 3:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Slow Opportunity/Quote Entry in 8.03.405A

Hi. Our quote team are extremely frustrated at the length of time it takes to do anything (add parts, delete parts, change operation details, saving). As I've read in other posts about other modules, Vantage gets more sluggish once 45 or more lines are in the quote.

It's taking 10-15 seconds to save the quote after altering a resource on an operation. This is with a 3GHz CPU (hyperthreading turned off), 2GB RAM, which appears to be in line with specs recommended in other posts. Similar times are reported for deleting materials, or dragging and dropping parts from other quotes.

(When a quote is small, and all is running well, 3-4 seconds is more normal... But many of our quotes are large, and segmenting them all is not an option.)

Any thoughts? Is this 'normal'? What can we try? Security settings?

What we are currently experimenting with is removing/disabling tabs etc that we don't use, which does seem promising. Anyone had success with this? Thanks.



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

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
4
We are on Progress. I take it Progress will probably have the equivalent option?
>
> We made things much better in .405 MSSQL by making our schema holder databases read-only.
>
5
Nope.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Kerry_Muntz
Sent: Thursday, April 23, 2009 9:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Slow Opportunity/Quote Entry in 8.03.405A

We are on Progress. I take it Progress will probably have the equivalent option?
>
> We made things much better in .405 MSSQL by making our schema holder databases read-only.
>




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

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