|
Home > Archive > IQ Server > March 2005 > Pass 1 and Pass2 Question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Pass 1 and Pass2 Question
|
|
| IQUser 2005-03-30, 7:08 pm |
| IQ Experts,
I am looking for some details on Pass1 and Pass2
while Loading the table using Insert , location select from
ASE into IQ. I am seeing mutliple threads are being used for
Pass1 and 0 threads for Pass2. Also, we are seeing more and
more time being spent on pass2 as the database size grows.
Could anybody share some details on this topic.
Thanks
| |
| David Walrath 2005-03-30, 7:08 pm |
|
Pass 1 is where all indexes except HG (HighGroup) and WD (Word) indexes
are loaded.
The input data for HG/WD indexes are first sorted (within IQ) before
loading; new data in these indexes is first sorted during Pass 1 and
then inserted during Pass 2.
IQUser wrote:
> IQ Experts,
> I am looking for some details on Pass1 and Pass2
> while Loading the table using Insert , location select from
> ASE into IQ. I am seeing mutliple threads are being used for
> Pass1 and 0 threads for Pass2. Also, we are seeing more and
> more time being spent on pass2 as the database size grows.
>
> Could anybody share some details on this topic.
>
> Thanks
|
|
|
|
|