Getting Data In

DB Connect - Query timed out Issue

spl_unker
Explorer

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

TIA

0 Karma

isoutamo
SplunkTrust
SplunkTrust

Hi

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!

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Announcing the General Availability of Splunk Enterprise Security 8.1!

We are pleased to announce the general availability of Splunk Enterprise Security 8.1. Splunk becomes the only ...

Developer Spotlight with William Searle

The Splunk Guy: A Developer’s Path from Web to Cloud William is a Splunk Professional Services Consultant with ...