data load qvw taking long in prod than test

[#1]

I am attaching a document which will show you how same qvw taking a lot of time in production to load same table and almost smae number of records in production compare to test.. In Test it finsihes in less than 10 minutes,, In production it is takin 30-50 minutes,,,, Please advise ASAP.

It is same qvw in both system

[alexandros17]

If you do not have data reduction on fields, a cause could be different access time to the DB ... have both the server the same odbc and DB drivers?

Check it

[#3]

Delay is from residnet load to another table.

[ashfaq_haseeb]

Hi,

Make sure you use same connector ODBC/OLEDB you use in test environment.

Also make sure if you have any reload and distribute task, try to separate reload task then that of distribution task,

Hope it helped.

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

Instead of loading it resident you can store and load it from qvd.

Hope it helped.

Regards

ASHFAQ

[#6]

When i run ,, there was nothing else running.... This has started just now.... Mystery is that it does same resident load in test so quickly as shown below  .. and this is not that one time ting,, we have been ruunig this in both environmets from last few days.

[ashfaq_haseeb]

Hi,

Its also depends on type of processor you have.

try by loading it from qvd instead of resident load.

Regards

ASHFAQ