Crystal Rpts slow vs Rpt Builder

Yahoo Archive
1
THANK YOU!!!! Seconds not minutes!

I really do appreciate this. You saved me so much time.

Juliet

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Shirley Graver
Sent: Friday, May 20, 2005 10:05 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Rpts slow vs Rpt Builder


Juliet,
Try this, Open your network (TCP) connection, go into
Properties for your TCP/IP if the field for the IP address of your DNS
server is blank enter the IP address of the DNS Server (which may be
different than your Vantage server) You should see an overall improvement in
network performance, which should help your odbc connection.

Shirley
2
I've created the same reports in CR and RB and notice that CR takes about 2
minutes to run and eats up 98% of CPU time (_sqlsrv2.exe) on W2000 Server,
whereas RB takes about 10 seconds and uses less than 10% of CPU time
(_mprosrv.exe).

I would prefer to use CR, because CR exports so cleanly into Excel.

Any ideas that could speed up CR?

On Vantage 5.2, Progress 9.1d09, CR 8.5

Thanks

Norm Watkins
Engineering Manager
ELECPAC
Phone: 847-639-2307
3
I would like to hear any performance increase options as well. After everyone helped me this week with my table joins, speed never did increase. I noticed it still took 10 minutes to verify the database. Something is drastically wrong with my ODBC connection to the Database if the rest of you connect in seconds. This got put on the back burner this week so I haven't had time to look at it.

Norm, If I find anything I will share.

Juliet

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Norm Watkins
Sent: Friday, May 20, 2005 9:48 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Crystal Rpts slow vs Rpt Builder


I've created the same reports in CR and RB and notice that CR takes about 2
minutes to run and eats up 98% of CPU time (_sqlsrv2.exe) on W2000 Server,
whereas RB takes about 10 seconds and uses less than 10% of CPU time
(_mprosrv.exe).

I would prefer to use CR, because CR exports so cleanly into Excel.

Any ideas that could speed up CR?

On Vantage 5.2, Progress 9.1d09, CR 8.5

Thanks

Norm Watkins
Engineering Manager
ELECPAC
Phone: 847-639-2307
4
Do you have a select statement on the company?

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Norm Watkins [mailto:nwatkins@...]
Sent: Friday, May 20, 2005 10:48 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Crystal Rpts slow vs Rpt Builder


I've created the same reports in CR and RB and notice that CR takes about 2
minutes to run and eats up 98% of CPU time (_sqlsrv2.exe) on W2000 Server,
whereas RB takes about 10 seconds and uses less than 10% of CPU time
(_mprosrv.exe).

I would prefer to use CR, because CR exports so cleanly into Excel.

Any ideas that could speed up CR?

On Vantage 5.2, Progress 9.1d09, CR 8.5

Thanks

Norm Watkins
Engineering Manager
ELECPAC
Phone: 847-639-2307



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/links
Yahoo! Groups Links
5
Juliet,
Try this, Open your network (TCP) connection, go into
Properties for your TCP/IP if the field for the IP address of your DNS
server is blank enter the IP address of the DNS Server (which may be
different than your Vantage server) You should see an overall improvement in
network performance, which should help your odbc connection.

Shirley

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Juliet Martin
Sent: Friday, May 20, 2005 10:57 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Rpts slow vs Rpt Builder

I would like to hear any performance increase options as well. After
everyone helped me this week with my table joins, speed never did increase.
I noticed it still took 10 minutes to verify the database. Something is
drastically wrong with my ODBC connection to the Database if the rest of you
connect in seconds. This got put on the back burner this week so I haven't
had time to look at it.

Norm, If I find anything I will share.

Juliet

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Norm Watkins
Sent: Friday, May 20, 2005 9:48 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Crystal Rpts slow vs Rpt Builder


I've created the same reports in CR and RB and notice that CR takes about 2
minutes to run and eats up 98% of CPU time (_sqlsrv2.exe) on W2000 Server,
whereas RB takes about 10 seconds and uses less than 10% of CPU time
(_mprosrv.exe).

I would prefer to use CR, because CR exports so cleanly into Excel.

Any ideas that could speed up CR?

On Vantage 5.2, Progress 9.1d09, CR 8.5

Thanks

Norm Watkins
Engineering Manager
ELECPAC
Phone: 847-639-2307


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/links



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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

Tracking #: 67ACD71D823042469FC723DFC2463EB855AF8DA4


[Non-text portions of this message have been removed]
6
Yes, and it's the first select statement.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Frank Zeigafuse
Sent: Friday, May 20, 2005 10:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Rpts slow vs Rpt Builder


Do you have a select statement on the company?

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Norm Watkins [mailto:nwatkins@...]
Sent: Friday, May 20, 2005 10:48 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Crystal Rpts slow vs Rpt Builder


I've created the same reports in CR and RB and notice that CR takes about 2
minutes to run and eats up 98% of CPU time (_sqlsrv2.exe) on W2000 Server,
whereas RB takes about 10 seconds and uses less than 10% of CPU time
(_mprosrv.exe).

I would prefer to use CR, because CR exports so cleanly into Excel.

Any ideas that could speed up CR?

On Vantage 5.2, Progress 9.1d09, CR 8.5

Thanks

Norm Watkins
Engineering Manager
ELECPAC
Phone: 847-639-2307



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










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