[
https://issues.apache.org/jira/browse/NIFI-1685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15212089#comment-15212089
]
ASF GitHub Bot commented on NIFI-1685:
--------------------------------------
GitHub user ToivoAdams opened a pull request:
https://github.com/apache/nifi/pull/304
NIFI-1685 Optimize database Junit tests to reduce execution time.
TestPutSQL and TestJdbcCommon are now optimized.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/ToivoAdams/nifi NIFI-1685
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/nifi/pull/304.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #304
----
commit a01ad7131e77e11490659ae62abced79980dc622
Author: Toivo Adams <[email protected]>
Date: 2016-03-25T16:51:00Z
NIFI-1685 Optimize database Junit tests to reduce execution time.
----
> Optimize database Junit tests to reduce execution time.
> -------------------------------------------------------
>
> Key: NIFI-1685
> URL: https://issues.apache.org/jira/browse/NIFI-1685
> Project: Apache NiFi
> Issue Type: Bug
> Components: Tools and Build
> Reporter: Toivo Adams
> Assignee: Toivo Adams
> Priority: Minor
> Labels: build, test
>
> Some database Junit tests are slow.
> For example:
> Running org.apache.nifi.processors.standard.TestPutSQL
> Tests run: 13, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 116.638 sec
> - in org.apache.nifi.processors.standard.TestPutSQL
> Running org.apache.nifi.processors.standard.util.TestJdbcCommon
> Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 20.029 sec -
> in org.apache.nifi.processors.standard.util.TestJdbcCommon
> Running org.apache.nifi.processors.standard.TestExecuteSQL
> Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 14.978 sec -
> in org.apache.nifi.processors.standard.TestExecuteSQL
> Running org.apache.nifi.processors.standard.util.TestJdbcHugeStream
> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 14.253 sec -
> in org.apache.nifi.processors.standard.util.TestJdbcHugeStream
> Running org.apache.nifi.processors.standard.QueryDatabaseTableTest
> Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 10.544 sec -
> in org.apache.nifi.processors.standard.QueryDatabaseTableTest
> My dev machine is not the fastest one, but still why waste time.
> One of reasons is creating DBCPService for each test.
> Setting up Connection pooling is expensive operation.
> So DBCPService should be set up only once and reuse in each test.
> Thanks
> Toivo
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
