I had forgotten that 9.x had a raw table type - thanks for pointing that
out. You will get light appends with this - which is the whole point of
doing the HPL song-and-dance. Looks like the FAQ may need updating.
Speaking of which - since it is STILL languishing waiting for inclusion in
the real FAQ (what's it been, 2 years?) - what is the status of that body of
work? Has David gone to take the dirt nap or something?

cheers
j.

----- Original Message -----
From: "Paul Watson" <paul@oninit.com>
To: <informix-list@iiug.org>
Sent: Tuesday, January 27, 2004 2:59 PM
Subject: Re: Releasing extents from a table.


> As Andy has mentioned Raw is exeptionally quick 1M+ rows per second
> but the absolute killer is the re-indexing.
>
> Andy Kent wrote:
> >
> > Not necessarily. If you create the new table as RAW then inserting
> > into it is EXTREMELY quick. However you have to ALTER it back to
> > STANDARD before you can put any primary key or indexes on it. Unless
> > the table has loads of indexes (including rowids) on it this is likely
> > to be a lot faster than two operations with HPL.
> >
> > Andy
> >
> > "Jack Parker" <vze2qjg5@verizon.net> wrote in message
news:<bv48ji$npj$1@terabinaries.xmission.com>...
> > > Unload, drop, recreate and reload. See the Informix Load FAQ.
> > > www.artentech.com/downloads.htm
> > >
> > > If you are using XPS you could just create a copy of the table, but
with 7x
> > > or 9x you'd want the performance of the HPL to move the data around.
> > >
> > > cheers
> > > j.
> > > ----- Original Message -----
> > > From: "JAMES SWALLOW" <JSWALLOW@greenbay.k12.wi.us>
> > > To: <informix-list@iiug.org>
> > > Sent: Monday, January 26, 2004 11:30 AM
> > > Subject: Releasing extents from a table.
> > >
> > >
> > > > I am in need of some general information about releasing extents
from a
> > > table that I will be trimming and releasing those extents back to the
> > > database. The information I have at hand is not clear about this
process.
> > > >
> > > > Thanx, Jim Swallow GBAPS
> > > >
> > > >
> > > >
> > > > sending to informix-list
> > >
> > >
> > > sending to informix-list
>
> --
> Paul Watson #
> Oninit Ltd # Growing old is mandatory
> Tel: +44 1436 672201 # Growing up is optional
> Fax: +44 1436 678693 #
> Mob: +44 7818 003457 #
> www.oninit.com #
>


sending to informix-list
sending to informix-list