We went to Server 2003 with a Dell quad 4 server with 8gb memory to
resolve this issue.
It helped tremendously with all reports.
Stephen Findley
IT Manager
281-353-1191 Office
713-419-4084 Cell
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of acp2g99
Sent: Friday, March 16, 2007 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.10x Reports on SQL Server
We run Vantage 8.000.810B on a SQL Server 2000 and some of our
Progress reports take about 25 minutes to run.
For example, our stock status report takes 25 minutes and more
sometimes to run and it is only 45 pages in length.
I have gone through multiple database tweaking with Epicor and Epicor
Partner consultants to no avail.
If you find ANY fix for the speed issue of a Vantage database on SQL
Server 2000, DEFINITELY KEEP ME INFORMED.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brad Feazell" <Brad_feazell@...>
wrote:
resolve this issue.
It helped tremendously with all reports.
Stephen Findley
IT Manager
281-353-1191 Office
713-419-4084 Cell
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of acp2g99
Sent: Friday, March 16, 2007 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.10x Reports on SQL Server
We run Vantage 8.000.810B on a SQL Server 2000 and some of our
Progress reports take about 25 minutes to run.
For example, our stock status report takes 25 minutes and more
sometimes to run and it is only 45 pages in length.
I have gone through multiple database tweaking with Epicor and Epicor
Partner consultants to no avail.
If you find ANY fix for the speed issue of a Vantage database on SQL
Server 2000, DEFINITELY KEEP ME INFORMED.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brad Feazell" <Brad_feazell@...>
wrote:
>influence on
> The number of lines on the S/O, P/O seems to have the most
> runtime. Here's what we see:"jameswi2000" <jameswi2000@> wrote:
>
> Sales Orders
>
> 1 line: 21 seconds
> 10 lines: 24 seconds
> 21 lines: 58 seconds
>
> Purchase Orders
>
> 1 line: 9 seconds
> 22 lines: 13 seconds
>
> These are averages based on three print previews of each order.
>
> Brad Feazell
> IT Manager | Dril-Quip, Inc.
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> >using
> > We would like to know what kind of speed people are seeing when
> > standard vantage reports on a Sql Server system? Inparticular,we
> aretaking to
> > interested in how long Sales Orders and Purchase Orders are
> > appear in print preview (our simply print). Are they taking acouple
> > of seconds, 15 seconds, 30 seconds, etc?results,
> >
> > If someone could time theirs with a stopwatch and post their
> > it would be much appreciated. We would like to use this info toget
> a[Non-text portions of this message have been removed]
> > baseline for which we can compare our system to.
> >
> > Thanks!
> >
>