Forum Discussion
Dataflow Timeout error
I have a dataflow which retrieves data from SQL Server. The result data is huge, it sometimes take more than 10minutes. Even though I changed the Command timeout to 1hr, still the evaluation gets ca...
Hi,Sadulabhanu
I am glad to help you.
According to your description, you want to know why you changed the Command timeout to 1h, still the evaluation gets cancelled in 10mins?
If I understand you correctly, then you can refer to my solution.
According to your description you have a very large amount of data, so you can try to optimize your data structure and also you can optimize your query algorithm. The complexity of the query is also something that can cause the query to timeout.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.