[SOLR-2006] DataImportHandler creates multiple DB connections during a delta update

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.4, 1.4.1, 3.1, 4.0-ALPHA
• Component/s: contrib - DataImportHandler
• Assignee: Unassigned
• Reporter: Lance Norskog
• Created: 19/Jul/10 23:38
• Updated: 24/Oct/16 02:02
• Resolved: 24/Oct/16 02:02

Description

The DataImportHandler code for delta updates creates a separate copy of each datasource for each entity in the document. This creates a separate JDBC connection for each entity. In some relational databases, connections are a heavyweight resource and their use should be limited.

A JDBC pool would help avoid this problem, and also assist in doing multi-threaded DIH indexing jobs.

Issue Links

• duplicates: SOLR-2233 DataImportHandler - JdbcDataSource is not thread safe