IDS Forum

RE: insert performance on fragmented table

Posted By: Habichtsberg, Reinhard
Date: Thursday, 28 August 2008, at 8:51 a.m.

In Response To: Re: insert performance on fragmented table (Fernando Nunes)

Hi,

I asked the same questions a week ago. My conclusion was to recreate the
table and unload/load.

The new discussion points in the direction that the effort could be saved: A
simple adding of some fragments to the round robin strategy seems to be
enough...?

Reinhard.

> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
> Fernando Nunes
> Sent: Thursday, August 28, 2008 2:22 PM
> To: ids@iiug.org
> Subject: Re: insert performance on fragmented table [13238]
>
>
> You reduced the chances of hitting one of the two full fragments.
> Before, nearly 66% of the time you hit a full fragment. Now,
> it should be
> 50%... Wonder why it was cut into half...
> On the other hand, before, 33% of the rows were a clean
> insert.... Now there
> should be 50%... Mathmatic is a funny thing :)
> Regards.
>
> On Thu, Aug 28, 2008 at 1:10 PM, PAUL SULLIVAN
> <paul.sullivan@compucom.com>wrote:
>
> > I added another dbspace and the insert time was cut in half.
> >
> > Thank you
> >
> > Paul Sullivan
> >
> >
> >
> >
> **************************************************************
> *****************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• insert performance on fragmented table
  PAUL SULLIVAN -- Wednesday, 27 August 2008, at 4:41 p.m.
  • Re: insert performance on fragmented table
    Richard Snoke -- Wednesday, 27 August 2008, at 5:19 p.m.
    • Re: insert performance on fragmented table
      Fernando Nunes -- Wednesday, 27 August 2008, at 6:56 p.m.
    • Re: insert performance on fragmented table
      PAUL SULLIVAN -- Thursday, 28 August 2008, at 8:10 a.m.
      • Re: insert performance on fragmented table
        Fernando Nunes -- Thursday, 28 August 2008, at 8:21 a.m.
        • RE: insert performance on fragmented table
          Habichtsberg, Reinhard -- Thursday, 28 August 2008, at 8:51 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.