Re: problem loading data
> dbaccess -V ; onmode -V; oninit -I
DB-Access Version 7.31.UC4Informix Dynamic Server Version 7.31.UC4
^|^|^|^|^|^|^|
(anyone know where the backups are?)
mmmm seems you are right... Worked fine for me though, I wonder which
other of these extensions work.. demn, didn't like static or operational
Would like to have played with GK indexes, we have a few tables that
are hit fairly hard and I can't just shove them memory resident since
they are large.
Which reminds me, the NOLRUPRIO actually causes my box to slow down!
Anyone got any ideas on that?
brett
Obnoxio The Clown 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
--
-----------------------------------------------------------------
Brett's 10th law of UNIX administration...
rm is forever
-----------------------------------------------------------------
Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings.
Tel. +27 31 717 4000 Direct. +27 31 717 4146
Fax. +27 31 717 4001
-----------------------------------------------------------------
The little voices are talking to me again, telling me to reach
for a keyboard and type rm -rf /*
last week they had me rm -rf `echo $MANPATH | sed 's/:/ /g'`
now I fear I have no answers
-----------------------------------------------------------------