Profile Picture

SQL Query timeout

Posted By Dan Jordan 11 Years Ago
Author
Message
Dan Jordan
Posted 11 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: Forum Members
Last Active: 9 Years Ago
Posts: 4, Visits: 2
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

Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1
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

Dan Jordan
Posted 11 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: Forum Members
Last Active: 9 Years Ago
Posts: 4, Visits: 2
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

Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1

"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





Similar Topics


Reading This Topic