What has row at a time processing, versus set based, got to do with page =
level versus row level locking???
Most programmers on planet earth have done the very same thing you trumpet =
you own abilities in doing.
So what?
Are you really as incredibly impressed with yourself as you would lead us =
to believe by your unending egocentrical posts; or are you on holiday and =
your worst enemy is gleefully destroying your credibility at your =
still-logged-in terminal?
Peter =22Had a gutsful of Pablo=22 Tashkoff
I was doing a bench for a customer and they were doing someQuote:>>> Pablo Sanchez <pablo=40sgi.com> 28/11/97 09:26:43 >>>
nightly processing... looking at their code, I saw that one
section was taking 2.5 hours. I rewrote it and that same
section took a couple of minutes. =20
What was the magic? Converted their row at a time logic to
set based logic.=20
--=20
Pablo Sanchez =7C Ph =23 (650) 933.3812 Fax =23 =
(650) 933.2821
pablo=40sgi.com =7C Pg =23 (800) 930.5635 -or- pablo_p=40p=
ager.sgi.com=20
---------------------------------------------------------------------------
----
I am accountable for my actions. http://reality.sgi.com/pablo =5B =
/Sybase_FAQ =5D