[ https://issues.apache.org/jira/browse/SOLR-5954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13958818#comment-13958818 ]
Raja Nagendra Kumar commented on SOLR-5954: ------------------------------------------- Patch attached > Slower dataimport process caused by not reusing jdbc connections > ---------------------------------------------------------------- > > Key: SOLR-5954 > URL: https://issues.apache.org/jira/browse/SOLR-5954 > Project: Solr > Issue Type: Bug > Components: contrib - DataImportHandler > Affects Versions: 4.7.1 > Reporter: Paco Garcia > Assignee: Mark Miller > Priority: Minor > Fix For: 4.8, 4.7.2 > > Attachments: SOLR-5954.patch > > > Hi, > SOLR-5734 introduced a regression that causes that the connections used in > the dataimport process were closed and reopen in every sql. > The change to nanoTime in the method getConnection of JdbcDataSource.java > forgot to convert the timeout used to reuse the connection. > The constant CONN_TIME_OUT must be changed to nanos to be compared. > (*1000*1000) > private Connection getConnection() throws Exception { > long currTime = System.nanoTime(); > if (currTime - connLastUsed > CONN_TIME_OUT) {<<<<<<<<<<<<<<< > synchronized (this) > { Connection tmpConn = factory.call(); closeConnection(); connLastUsed = > System.nanoTime(); return conn = tmpConn; } > } else > { connLastUsed = currTime; return conn; } > } > private static final long CONN_TIME_OUT = 10 * 1000; // 10 seconds > Regards -- This message was sent by Atlassian JIRA (v6.2#6252) --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org