I have

[paulyeo11]

Hi All

i have 10 QVD file all the same , it work fine for 2 year. Total i create another unqie table when i Concatenate with the 10 QVD file , i the whole database become very slow and not working.

This new QVD table have all the same field with 10 QVD table. except 1 additional field name i add .I try to use NoConcatenate , it also never help to solve the problem. Can some one give me suggestion ?

PRICE:

load * from $(vQVDPath)BECKHOFF.qvd (qvd);

Concatenate

load * from $(vQVDPath)HAKKO.qvd (qvd);

Concatenate

load * from $(vQVDPath)MITSUBISHI.qvd (qvd);

Concatenate

load * from $(vQVDPath)GE.qvd (qvd);

Concatenate

load * from $(vQVDPath)HMS.qvd (qvd);

Concatenate

load * from $(vQVDPath)KEB.qvd (qvd);

Concatenate

load * from $(vQVDPath)REDLION9.qvd (qvd);

Concatenate

load * from $(vQVDPath)SCM.qvd (qvd);

Concatenate

load * from $(vQVDPath)KINCO.qvd (qvd);

Concatenate

load * from $(vQVDPath)POWER_SUPPLY.qvd (qvd);

// below table create problem.

noConcatenate

load * from $(vQVDPath)LOCAL_TID.qvd (qvd);

[kiranmanoharrode]

Give Table name to 11th table,

Use below script:

PRICE:

load * from $(vQVDPath)BECKHOFF.qvd (qvd);

Concatenate

load * from $(vQVDPath)HAKKO.qvd (qvd);

Concatenate

load * from $(vQVDPath)MITSUBISHI.qvd (qvd);

Concatenate

load * from $(vQVDPath)GE.qvd (qvd);

Concatenate

load * from $(vQVDPath)HMS.qvd (qvd);

Concatenate

load * from $(vQVDPath)KEB.qvd (qvd);

Concatenate

load * from $(vQVDPath)REDLION9.qvd (qvd);

Concatenate

load * from $(vQVDPath)SCM.qvd (qvd);

Concatenate

load * from $(vQVDPath)KINCO.qvd (qvd);

Concatenate

load * from $(vQVDPath)POWER_SUPPLY.qvd (qvd);

// below table create problem.

noConcatenate

LOCAL_TID:

load * from $(vQVDPath)LOCAL_TID.qvd (qvd);

[jonathandienst]

Paul

If you are adding the last load into a separate table, you are creating a synthetic key with all the fields in the existing table. This will likely have a severe performance impact. Rather concatenate the new table to the existing table. The new field will be null for all the existing sources. You will need to force the concatenation with Concatenate as the field list is not identical.

HTH

Jonathan

[paulyeo11]

Hi All

Thank you for your advise. but i still unable resolve the issue.

Enclosed is my 3 QV doc .

1. first 10 table QVD . ( working fine ).

2. last table QVD. ( working fine ).

3. combine of above 2 table ( not working ).

Paul

[paulyeo11]

Hi All

it was my mistake , in my last table i accidently create a field name Currency_P.

in the first 10 table it was created by :-

LOAD * INLINE [

Currency_P, RATE_P

SG, 1

MY, 2.65

INDO, 9500    

THAI, 25

];

So my last table field name force the whole table Currency_P = INDO

I manage to find out when I try to create Local Product Table for MY , same thing happen , then i know where i make the mistake.

Thank you , now i can move on.

Paul