Re: [SQL] perfomance question

On Mar 18, 2004, at 11:27 PM, sad wrote: On Thursday 18 March 2004 21:38, you wrote: Sad, what are perfomance difference bitween a) update t1 set f1 = 'x', f2 = 'y'; b) update t1 set f1 = 'x', f2 = f2; c) update t1 set f1 = 'x'; ? Not a lot. Why don't you try it? Really ! why ? :-) I forgot

Re: [SQL] perfomance question

On Thursday 18 March 2004 21:38, you wrote: > Sad, > > > what are perfomance difference bitween > > a) update t1 set f1 = 'x', f2 = 'y'; > > b) update t1 set f1 = 'x', f2 = f2; > > c) update t1 set f1 = 'x'; > > ? > > Not a lot. Why don't you try it? Really ! why ? :-) I forgot to ask the sec

Re: [SQL] perfomance question

Sad, > what are perfomance difference bitween > a) update t1 set f1 = 'x', f2 = 'y'; > b) update t1 set f1 = 'x', f2 = f2; > c) update t1 set f1 = 'x'; > ? Not a lot. Why don't you try it? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcas

Re: [SQL] Date format issue

Stephan Szabo <[EMAIL PROTECTED]> writes: > You didn't say what version you're using, but IIRC, there was a bug which > caused the above sort of behavior. I think it was fixed in 7.4 and could > be fixed in 7.3.x with a catalog change which you might be able to find in > the archives. Good memory