Query output takes much time to download

[Former Member]

Hi Experts,

I am running an query in SQ01 and getting output of 40000 row. The query execution is very faster but when I try to download the output to local file it take lot of time to download. Initially it was giving RUN TIME error then I increased the rdisp/max_wprun_time to 1200, now it is saving to the local file but takes 30 minutes.

So, can anybody tell me if there is any way to resolve this issue?

Note: The system performance is excellent and this is a QAS system

Regards,

Nilesh

[Former Member]

Hi,

You can't really do much here, excpet trying to download the output in another format or maybe trying to split your query to fetch less no. of records.

Hope this helps.

Regards,

Varun