|Subject||RE: [firebird-support] parrallel update - Email found in subject|
> > Or is this what you're already doing, just that your example wasI would disagree!
> > 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
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.