Re: problem loading data

Posted in 2000

Obnoxio The Clown — Fri, 08 Dec 2000 13:54:03 -0000 — source: Informix-list mailing list archive (1991-1998)

From: Brett Geer <brett@brabys.co.za> > >Read the manual? I did. It says that RAW tables are an XPS-only extension. (Current Informix Guide to SQL: Syntax, page 2-230) > > How'd you create a raw table in 7.31? > >create raw table bob >( > an integer >);> >alter table bob type (standard);> >voila. > >Some history for a friday giggle, we were comparing our engine's >performance on ugly queries vs m$sql... I wont mention the timings >but we didn't get a chance to laugh at m$ before it finished. > >The raw table eliminated the loggin on the load of a few hund K >records from a phat file. Ok, a temp table would have done it aswell, >but I was playing. Crap. I used to look like a fool for not reading the manual, now I look like a fool for reading the manual. :-( _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com

↪ replying to Obnoxio The Clown

William Rice — Fri, 08 Dec 2000 14:43:56 GMT — source: Informix-list mailing list archive (1991-1998)

In article <90qqd9$luo$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > From: Brett Geer <brett@brabys.co.za> > > > >Read the manual? > > I did. It says that RAW tables are an XPS-only extension. (Current Informix > Guide to SQL: Syntax, page 2-230) > > > > How'd you create a raw table in 7.31? > > > >create raw table bob > >( > > an integer > >);> > > >alter table bob type (standard);> > > >voila. > > > >Some history for a friday giggle, we were comparing our engine's > >performance on ugly queries vs m$sql... I wont mention the timings > >but we didn't get a chance to laugh at m$ before it finished. > > > >The raw table eliminated the loggin on the load of a few hund K > >records from a phat file. Ok, a temp table would have done it aswell, > >but I was playing. > > Crap. I used to look like a fool for not reading the manual, now I look like > a fool for reading the manual. :-( > > ________________________________________________________________________ _____________ > Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com > > Blame it on Informix for providing a GREAT feature, and then taking it away. I seem to recall 9.3 is supposed to have raw tables. Will Sent via Deja.com http://www.deja.com/ Before you buy.