Fetching 4,00,000 records from External DB

Hi,


I have written SQL query in order to fetch the 4,00,000 records from External DB. But, in between, timeout error occurred while executing the query. Kindly help me to resolve this issue.


Regards,

Divya. 

Hi Divya,

A web request has a limited time out and is not suitable for these type of long running task s.

Code your logic in a timer and set the timeout to the timer to be able to do the job.

Regards,

Daniel

Hi Divya, 

I am wondering... Why do you need to fetch all those records? 

What are you trying to do? What's your use case? 

Cheers