SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 08:03 PM
| ||||
| ||||
 Re: Releasing extents from a table. 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      |
|
04-19-2008, 08:03 PM
| |||
| |||
| Re: Releasing extents from a table. And for unload / reload use HPL. You have to be patient when configuring jobs but after that ... nebojsa On Mon, 26 Jan 2004 18:20:43 -0400, "Jack Parker" <vze2qjg5@verizon.net> wrote: > >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 ------------------------------------ Remove spam block (DELETE_) to reply |
|
04-19-2008, 08:03 PM
| |||
| |||
| Re: Releasing extents from a table. 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 |
|
04-19-2008, 08:03 PM
| ||||
| ||||
| 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 # |
Linear Mode
