row level vs page level locking is it more than marketing
Posted in 1997
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 >>> Pablo Sanchez <pablo=40sgi.com> 28/11/97 09:26:43 >>> I was doing a bench for a customer and they were doing some 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