Re: Query optimization time with Calcite

2023-08-23 Thread Abhijit Subramanya
-up the next queries will be planned faster and faster. > > If you use Calcite as a part of a server application, then the problem > with a long query planning will be eliminated after a few query runs. > > Thanks. > > -- > > Roman > > On 23.08.2023 01:33, Abhijit

Query optimization time with Calcite

2023-08-22 Thread Abhijit Subramanya
Hi, I am currently working with Apache Calcite and using the VolcanoPlanner to optimize queries. I've noticed that the planner.setRoot() function can take approximately 100ms to complete. After some profiling, it appears that the JaninoRelMetadataProvider.compile function might be the