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!

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

Ref Cursor Speed

Status
Not open for further replies.

Thadeus

Technical User
Jan 16, 2002
1,548
US
Hello again.... I am now connecting to the Weakly Bound Ref Cursor with no problem. (Thanks SynapseVampire)

Here's the new issue: SPEED!
When I run against the Ref Cursor, It takes about 57 secs (not ms) to "Read Records"
When I run against the Table itself, it takes about 1.6 secs
to "Read Records"

The time to "query DB" is longer with the ref cursor but not significantly when talking in milliseconds....

Can I speed this up with the Ref cursor?

Thanks in advance....
Thadeus
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top