Re: parse/bind/execute

Please do not top-posts on these lists.

On Wednesday, June 4, 2014, Huang, Suya <Suya(dot)Huang(at)au(dot)experian(dot)com> wrote:

> Thank you David, I copied the detailed activity from the report as below.
> As it shows, it has prepare and bind queries. One of the item has
> Bind/Prepare pretty high as 439.50. so that looks like a good value?
>
> Another question is if bind only happens in a prepared statement?
>
> Day Hour Prepare Bind Bind/Prepare Percentage of
> prepare
> Jun 03 00 205 209 1.02 1.27%
> 01 19 19 1.00 0.17%
> 02 0 0 0.00 0.00%
> 03 0 0 0.00 0.00%
> 04 6 6 1.00 0.00%
> 05 2 879 439.50 0.02%
> 06 839 1,323 1.58 7.01%
> 07 0 0 0.00 0.00%
>
>
>
Yes. Something that high usual involves batch inserting into a table. To
be honest, a global picture is of limited value for this very reason.
Representing all of your usage as a single number is problematic.
Breaking it down by hour as done here increases the likelihood of seeing
something useful but typically that would be by chance. In this case
because batch processing is done in the early morning and few users are
probably on the system (a common source of one-off statements) the numbers
here are dominated by the special case of bulk inserts and are not typical
of normal activity and performance.

David J.