Re: [h2] In memory query optimizations

2021-10-25 Thread 0lst...@gmail.com
I'm not sure to understand. For my use case I cannot rely on any schemas. This is why I use H2 mainly to figure out what are the fields to replace with values. H2 can infer it when parsing string expressions (ExpressionColumn objects are the fields to replace). Br, On Monday, 25 October 2021

Re: [h2] In memory query optimizations

2021-10-25 Thread Noel Grandin
Trying to use H2's internals directly is not a good place to start. Rather use the JDBC API. I wouldn't bother setting any parameters initially unless you run into a problem, H2 is pretty fast out the box. -- You received this message because you are subscribed to the Google Groups "H2

[h2] In memory query optimizations

2021-10-25 Thread Ol Strom
Hello, I'd like to use H2 to parse and execute prepared queries, without storing tables. These queries are quiete simple (without any join, order, sub queries, ...). Most of the time it is something like: - SELECT a = 2 and b = 5; - SELECT CASE WHEN a = 2 and b = 5 THEN 1 ELSE 0 END; Here