SQL Query via MID SERVER

johngomes
Tera Contributor

‎06-14-2025 06:46 AM

Hi everyone,

 

I have an SQL query that is taking a long time to return the result of the query via DataSource. The volume of data that the query retrieves is large, around 900 thousand rows.
However, when testing the query on SQL Server, it runs with an average time of 15 seconds, but when testing via DataSource, it exceeds the Mid Server timeout of 300s, so the operation is aborted.
Splitting this query would make me have to run several DataSources instead of just 1... does anyone have any suggestions on how to solve this?

0 Helpfuls
  • 436 Views
1 REPLY 1

VikMach
Mega Sage

‎06-14-2025 07:14 AM

Hi @johngomes, have you tried "limit" and "offset" methods in your SQL query to fetch the data incrementally rather than fetching all at once due to time out.
If not, see example here - https://www.w3schools.com/mysql/mysql_limit.asp.

Let me know if this works.

Regards,
Vikas K

0 Helpfuls