Re: count of Parse/Execute = Fetch in tkprof

Hi,
 you are parsing the statement each time you execute it.  the way to go is to define a cursor, parse the statement once and  keep it.
 next time you have the same sql, just bind new values and execute/fetch.

Karsten

In article <86i4uj$pfc$1_at_nnrp1.deja.com>,   screwbai_at_my-deja.com wrote:
> Doing tkprof when browsing in my application. I found that the number
of
> parses/executes is equal to the number of Fetches. Rather unusal since
> the sql is small and shared_pool size is about 15MB. Should be enough
> for a single user. This means that for each fetch the sql is doing it
> parses the sql each time without taking it from the shared_pool.
>
> Is there anything that could make it not go into the shared pool.
>
> Using a network sniffer I can see the sql going across from the client
> multiple times. But once should be enough.
>
> Using Borland client.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 25 2000 - 07:36:10 CST