Update Operation
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.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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