ERROR-LIMIT-MAX-ROWS-DBCONNECT

[amelbahrouni]

Hello,
The question is about DB-Connect, actually I’m already connected to a DB-Connect (Version 3.1.4) ) but when I’am fetching on that SQL DB using SQL query on SPLUNK , this search displays only results 100000 rows ( the limit for DB Connect to display results ) .But, my search normally displays more than 100000 rows. Cause, I need that result to make a mathematical operation ! How can I obtain all the rows of my DB Table !! The table on this DB is composed by data.
Thanks in advance and cooperation

[wmyersas]

Are you hitting the row limitation in the DB COnnect preview screen?

Or when running searches against the data after you import?

I've imported DB tables with upwards of 500,000 entries, no problems (other than it takes a while to complete, of course)

And I've done "nothing special" - just run the query, and let it import

[amelbahrouni]

Hello , Sorry i did a mistake so i delete all my previous questions ,so at first thanks for your response ! so my DB Table contain 23935964 rows , For your question , yes Both !! DB COnnect preview screen and when i run the search ! (Just in SQL server i obtain all the rows that i need to make my operation ) !!
Please can you tell me how you did that ! i mean how did you import all the data that you need !! ( with your DB table 500.000) !!
Thanks in advance .

[wmyersas]

I don't really know what to say here: regardless of how many rows I've imported (and it's been as many a million plus), it's Just Worked™

[amelbahrouni]

Hello Again , at first thanks for your response , very good !! you did that with a millions rows ! can you tell me about how you did that please ! i count on you to help me !
Thanks in advance .

[wmyersas]

Please reread my last comment: I didn't "do" anything - running the dbconnect Just Worked™