Update Operation
Posted in 2012
Shahzad Salam Kasi asked whether IDS 11.50.FC8W3 updates rows in place or deletes and inserts. Art Kagel said records are updated in place. Jack Parker added that if a varchar grows and no longer fits, the row moves to a new page. Jonathan Leffler said as far as he knew a forwarding pointer is left on the old page.
Topics: Platform-Specific Issues
Hi, I would like to know the internal operation of IDS Engine during Update Operation. Whether, the Engine Updates the record or it performs delete & insert operation during the update activity. We are using IDS 11.50.FC8W3 on Solaris Sparc. Thanks.
Records are updated in place, not replaced. Art On May 25, 2012 1:09 PM, "SHAHZAD SALAM KASI" <skasi@i2cinc.com> wrote: > Hi, > I would like to know the internal operation of IDS Engine during Update > Operation. > Whether, the Engine Updates the record or it performs delete & insert > operation during the update activity. > > We are using IDS 11.50.FC8W3 on Solaris Sparc. > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae93408937cfba704c0df7525
Provided they still fit in the same place. If a varchar field has = increased in size, the row will be moved to a new page. j. On May 25, 2012, at 1:11 PM, Art Kagel wrote: > Records are updated in place, not replaced.=20 >=20 > Art=20 > On May 25, 2012 1:09 PM, "SHAHZAD SALAM KASI" <skasi@i2cinc.com> = wrote:=20 >=20 >> Hi,=20 >> I would like to know the internal operation of IDS Engine during = Update=20 >> Operation.=20 >> Whether, the Engine Updates the record or it performs delete & insert=20= >> operation during the update activity.=20 >>=20 >> We are using IDS 11.50.FC8W3 on Solaris Sparc.=20 >>=20 >> Thanks.=20 >>=20 >>=20 >>=20 >>=20 > = **************************************************************************= *****=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=20= >>=20 >>=20 >=20 > --14dae93408937cfba704c0df7525=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20
On Fri, May 25, 2012 at 10:20 AM, Jack Parker <jack.parker4@verizon.net>wrote: > Provided they still fit in the same place. If a varchar field has > increased in size, the row will be moved to a new page. > The data will be moved (if it doesn't fit in the original page), but a forwarding pointer will be left on the old page, AFAIK. > > On May 25, 2012, at 1:11 PM, Art Kagel wrote: > > Records are updated in place, not replaced. > > On May 25, 2012 1:09 PM, "SHAHZAD SALAM KASI" <skasi@i2cinc.com> = > wrote: > >> I would like to know the internal operation of IDS Engine during Update > >> Operation. > >> Whether, the Engine Updates the record or it performs delete & insert > >> operation during the update activity. > >> We are using IDS 11.50.FC8W3 on Solaris Sparc. > -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --e0cb4efe2f42bd56e104c0e090a4