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]
