SQL Query timeout


https://www.nevron.com/Forum/Topic7730.aspx 		Print Topic | Close Window

By Dan Jordan - 11 Years Ago
Is there a way to adjust the SQL query timeout for the chart? I have queries that are coming in at just over 30 seconds that throw the timeout error.

It looks like it can't be adjusted at the connection string level, since the timeout is actually a command property.

Thanks in advance,
Dan Jordan
By Bob Smith - 11 Years Ago
Have you tried creating a View in SQL Server or MySQL that already has your query data within it? Might save you some time on the connection... I'm definitely not an expert, but it might help
By Dan Jordan - 11 Years Ago
Bob,

I've tried all sorts of performance tuning ideas on these queries. Some of the tables they are referencing have billions of rows. (I almost want to say that in a Carl Sagan voice.)

In some cases, we've created what we call "extract tables" (almost like data warehouse fact tables, but more report-specific) to help speed up some of the queries, where nothing else has seemed to work. There's an ETL-like process to load them, so some would say they are fact tables, and we may include them in the DW in the future.

Since then, Nevron's added the ability to specify a command timeout for database queries, so they've come to the rescue on this situation too.

Thanks for replying.

Dan
By Bob Smith - 11 Years Ago

"To make an apple pie, first you must create the universe"

Sorry I didn't have a good answer for you! Glad that the Nevron guys came through. Best of luck