Re: Buffer size, cursors, paging and Pro*C performance?

patrick_at_casbs.Stanford.EDU (Patrick Goebel) wrote:

>RDBMS V 6.033, Pro*C 1.5
 

>I hope I can describe this in a way that makes sense: I have a Pro*C
>program that builds a select statement as a VARCHAR string, then
>prepares it, opens it as a cursor, then fetches from it. It all works
>fine. However, whenever the select string reaches a certain length
>(or complexity, I'm not sure which), the execution time bogs way
>down--from 1.5 seconds to 13 seconds! Whenever the program runs slow,
>I can hear disk activity (as if something is being paged) whereas when
>it runs fast, I do not hear any disk activity.

Have you tried running the same SQL statement via SQLPLUS and compared the execution times? It may be the statement itself.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

If at first you don't succeed, sky-diving isn't for you.