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. 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      |
|
04-19-2008, 08:04 PM
| |||
| |||
| Re: Releasing extents from a table. Doesn't HPL do something to speed up inserting into the indexes that you can't do with TYPE RAW? Are there SQL equivalents for all of HPL's jiggery-pokery or not? > Has David gone to take the dirt nap I don't know what this means but Roger's Profanisaurus comes to mind .... Andy "Jack Parker" <vze2qjg5@verizon.net> wrote in message news:<bv70fn$2pk$1@terabinaries.xmission.com>... > 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 |
|
04-19-2008, 08:06 PM
| ||||
| ||||
| Re: Releasing extents from a table. Andy Kent wrote: > Doesn't HPL do something to speed up inserting into the indexes that > you can't do with TYPE RAW? Are there SQL equivalents for all of HPL's > jiggery-pokery or not? > >> Has David gone to take the dirt nap > > I don't know what this means but Roger's Profanisaurus comes to mind Been buried? -- "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche |
Linear Mode
