Re: unloading a table more efficiently...
Hi Kaien,
I believe loading the table takes more time, but the index creation takes a
long time as well.
I don't use any of the two configuration settings you mentioned.
Please explain the importance of the two parameters.
Our application is mainly OLTP. However, there are transactions that would
be classified under DSS. I currently don't have a value for parameter
DS_TOTAL_MEMORY.
How do I set the PDQPRIORITY? I believe it's an ENV variable, right?
We only have one CPU on our machines. Will PDQPRIORITY still be useful?
TIA
Regards,
Denmark W.
----- Original Message -----
From: <kaien@neowiz.com>
To: <informix-list@iiug.org>
Sent: Wednesday, February 07, 2001 2:00 AM
Subject: Re: unloading a table more efficiently...
> What takes most of your time?
> Loading table? or creating index?
> If u spend most of your time in creating index,
> check if your DS_TOTAL_MEMORY in onconfig is properly set,
> and set PDQPRIORITY to 100.
>
>
> Denmark B. Weatherburn <dweatherb@btl.net> wrote:
>
> > Hi Informix Users,
>
> > I need your advice again.
> > We are a financial institution in Belize ("Temptation Island").
> > We are running Solaris 2.7 with Informix IDS Workgroup Server 7.30.UC3.
> > I (SysAdmin/DBA) want to improve the loading of a GL history table.
> > Statistics on table:
>
> > Kbytes Mbytes
> > tabname rowsize nrows nrows*size nrows*size nexts
> > mch 494 1064897 513729.6 501.7 178
>
> > ndatapgs Pgs=>Mb npgsused Pgs=>Mb npgsalloc Pgs=>Mb
> > 266225 1039.9 293311 1145.7 294784 1151.5
>
> > From dbschema in dbexport directory:
>
> > { TABLE "opsi".mch row size = 494 number of columns = 68 index size =
838 }
> > { unload file name = mch__00458.unl number of rows = 1064897 }
>