Getting Data In

DB Connect - Query timed out Issue


Im setting up a new DB connect. While creating inputs i could execute the SQL query and get results in Batch Mode. Where as when i execute the same query in Rising Column mode (which adds Order by clause to the query) takes more time and i get query time out message.

I suspect this is because  the initial query pulls entire records which is around 13 Million records

Please suggest if there is any alternate method?

Query im using :

Select * from table_name where column_name1  LIKE %abc% AND column_name2 > ? ORDER BY column_name2 ASC


Labels (1)
0 Karma



have the column_name2 index in dB? If not then I propose that it will be added. Otherwise the only option is increase timeout parameter for this input query.

r. Ismo

0 Karma
Get Updates on the Splunk Community!

.conf23 Registration is Now Open!

Time to toss the .conf-etti 🎉 —  .conf23 registration is open!   Join us in Las Vegas July 17-20 for ...

Don't wait! Accept the Mission Possible: Splunk Adoption Challenge Now and Win ...

Attention everyone! We have exciting news to share! We are recruiting new members for the Mission Possible: ...

Unify Your SecOps with Splunk Mission Control

In today’s post, I'm excited to share some recent Splunk Mission Control innovations. With Splunk Mission ...