Skip to Content
avatar image
Former Member

Query output takes much time to download

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 02, 2011 at 07:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded