drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2863) Slow code generation/compilation(/scalar replacement?) for getColumns(...) query
Date Thu, 23 Apr 2015 20:51:39 GMT
Daniel Barclay (Drill) created DRILL-2863:
---------------------------------------------

             Summary: Slow code generation/compilation(/scalar replacement?) for getColumns(...)
query
                 Key: DRILL-2863
                 URL: https://issues.apache.org/jira/browse/DRILL-2863
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Daniel Barclay (Drill)


Calling Drill's JDBC driver's DatabaseMetaData.getColumns(...) method seems to take an unusually
long of time to execute.

Unit tests TestJdbcMetadata and Drill2128GetColumnsDataTypeNotTypeCodeIntBugsTest have gotten
slower recently, seemingly in several increments:  They needed their timeouts increased, from
around 50 s to 90 s, and then to 120 s, and that 120 s timeout is not long enough for reliable
runs (at least on my machine).

>From looking at the logs (with sufficiently verbose logging), it seems that the large
SQL query in the implementation of getColumns() (currently in org.apache.drill.jdbc.MetaImpl)
is leads to 513 kB of generated code.

That half a megabyte of generated Java code frequently takes around 110 seconds to compile
(on my machine). 





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message