Thanks for the feed back. It appears that there is an index selection error
and in fact development will correct it "on a forth coming release" for
those interested you can refer to call 695390.

-----Original Message-----
From: crobisch1@... [mailto:crobisch1@...]
Sent: Thursday, May 10, 2001 2:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Advance Payment Balance - 5.019

Tried it on a 410mb version 5.00.319 database and it finished in
about 25 min. It appeared to read the tables and then heavily use the
CPU.

--- In vantage@y..., "Keith . Mailloux" <kmailloux@f...> wrote:
> Has anyone tried to run this report under AP? I have a 600Mb
databse and the
> report just hangs/runs. Tried for 30 minutes and ended the task?
Support
> said it MAY be bad data but they don't have much for performance
measures.
> Can someone try this a respond directly to me? Thanks

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=190462.1393721.2979173.2/D=egroupmail/S=1700007183:N/
A=551014/?http://www.debticated.com> www.debticated.com

<http://us.adserver.yahoo.com/l?M=190462.1393721.2979173.2/D=egroupmail/S=17
00007183:N/A=551014/rand=938621115>

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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.

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

Hi,

I just tried it for over 2 hours before killing it.

Database is 775MB in size on a Duel 733PII with 768MB RAM Windows 2000.

Not so hot is it.

Regards,

Ron Newell
IT/MIS
Neon Products
1695 Sargent Ave.
Winnipeg, MB R3H 0C4
http://www.neon-products.com/
mailto:rnewell@...

This message is intended only for the use of the person(s) ("intended
recipient")
to whom it is addressed. It may contain information which is privileged and
confidential.
If you are not the intended recipient please contact the sender as soon as
possible.
Accordingly any dissemination, distribution, copying or other use of this
message or any
of its content by any person other than the Intended Recipient is strictly
prohibited. We
have taken every precaution to ensure that this message is virus free but
we can not be
responsible for any damage that may be caused by its content.

-----Original Message-----
From: Keith . Mailloux [mailto:kmailloux@...]
Sent: Tuesday, May 08, 2001 2:48 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Advance Payment Balance - 5.019

Has anyone tried to run this report under AP? I have a 600Mb databse and the
report just hangs/runs. Tried for 30 minutes and ended the task? Support
said it MAY be bad data but they don't have much for performance measures.
Can someone try this a respond directly to me? Thanks

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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Tried it on a 410mb version 5.00.319 database and it finished in
about 25 min. It appeared to read the tables and then heavily use the
CPU.

--- In vantage@y..., "Keith . Mailloux" <kmailloux@f...> wrote:
> Has anyone tried to run this report under AP? I have a 600Mb
databse and the
> report just hangs/runs. Tried for 30 minutes and ended the task?
Support
> said it MAY be bad data but they don't have much for performance
measures.
> Can someone try this a respond directly to me? Thanks