|Subject||Re: [firebird-support] parrallel update - Email found in subject|
|Author||Vander Clock Stephane|
ok, i will try the parametized queries to see ...
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
> > variantes)
> I would disagree!
> Your test was skewed and did not reflected the reality of
> prepare/parameterized statements! (the 2 scenarios are "apples and
> 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
> 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.
[Non-text portions of this message have been removed]