I am new to calcite too. Did not see much discussion or documentation regarding calcite performance. Have anyone done any benchmark to evaluate calcite’s performance impact? Or is there any documentation regarding performance concern? Thanks,
-JD > On Jun 7, 2017, at 9:59 AM, Datta Mane <[email protected]> wrote: > > Hi > New to calcite, running some basic test against local mysql db > > Problem: When executed a query having multiple join and group by with calcite > it takes double the time to get results as compared to getting results from > normal jdbc statement > > Questions : > 1. Am I doing this correctly? > 2. if yes why is it taking so much time to return results > 3. What is the efficient way to get results faster than normal jdbc > connection ? > > Below is result from attached java code > hikariConnectionPoolTest:Time to get data from local DB using Hikari > :715719320 (0.7s) > runQueryWithCalcite:Time to get data from local DB using Calcite Prepared > statement 1:5491470347 (5.5 sec) > runQueryWithCalcite2: Time to get data from local DB using Calcite 2045749851 > (2.0) > runQueryWithCalcite3: Time to get data from local DB using Calcite > :1788924134 (1.7) > > > > > <ConnectionManagerTest.java.txt>
