Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Slow performance Crystal 2008 against Oracle 10g Stored Procedure

Status
Not open for further replies.
MJRBIM

MJRBIM

MIS
May 30, 2003
1,579
0
0
CA
Crystal 2008 against an Oracle 10g Stored Procedure using Crystal "Oracle Native" connection..

The report runs MUCH slower when running against the Stored Procedure - vs a RPT that goes against a TABLE or VIEW.

It is also MUCH slower than running the Stored Procedure via TOAD, etc with same Oracle USER_ID.

Anyone seen this issue before and know of a fix...?

Thanks in advance.

Senior Business Intelligence Consultant
Toronto, Canada

SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services
 
Status
Not open for further replies.

Similar threads

Kennymc
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
167
Kennymc
Kennymc
Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
136
dgillz
dgillz
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
172
hilfy
hilfy
BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
145
hilfy
hilfy
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
135
Ivan Kok
Ivan Kok

Part and Inventory Search

Sponsor

Back
Top