Doug McNaught wrote:
>
> Joseph Shraibman <jks@selectacast.net> writes:
>
> > Compared to 1000 updates that took between 25 and 47 seconds, an update
> > with 1000 itmes in the IN() took less than three seconds.
>
> Did you wrap the 1000 separate updates in a transaction?
>
> -Doug
No, at a high level in my application I was calling the method to do the
update. How would putting it in a transaction help?
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com