ok, i will try the parametized queries to see ...

thanks !

On 1/26/2012 11:19 PM, Leyne, Sean wrote:
>
> > > Or is this what you're already doing, just that your example was
> > > simplified?
> > >
> > > HTH,
> > > Set
> > >
> >
> > yes, of course parametized queries will be more fast, but i don't
> think they
> > will change the ratio in the test (it's will simply be more fast for
> both
> > variantes)
>
> I would disagree!
>
> Your test was skewed and did not reflected the reality of
> prepare/parameterized statements! (the 2 scenarios are "apples and
> oranges")
>
> By using un-prepared statements, you reduced the disk IO load of your
> test and thus the overhead of Classic server page synchronization. In
> essence your test created "openings" to allow for multiple disk IO to
> occur.
>
> Using prepared statements will increase the speed of a single
> connection but also increase the synchronization overhead and disk
> contention. Thus reducing the benefit of parallel connections.
>
> Sean
>
>


[Non-text portions of this message have been removed]