[h2] Re: Query Optimizer limitations

[Adam McMahon]

Hi,

when you say performance is very bad, what do you mean?  What is slow to 
you?  By slow, do you mean slow compared to other databases?  Does it use 
index?  Do you expect the querry to use an index that it is not using (try 
the explain method to learn about what the query is doing behind the 
scenes).



On Tuesday, January 17, 2017 at 12:20:26 PM UTC-5, Anil Dasari wrote:
>
> Hi,
>
> I have created a simple join query between two tables and performance is 
> very bad.
>
> I read the documentation and understand that query optimizer have some 
> limitations. i would like to go thorough them before actually posting the 
> my query having the issues.
>
> Could you please point me to the query optimizer limitations ? thanks.
>
> Thanks.
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Re: [h2] Re: Voting up for SQL Trigger

[Noel Grandin]

I'd be happy with a patch that did that
On Tue, 17 Jan 2017 at 22:47, Yan  wrote:

> Fair enough Noel.
>
> What about opening up inline java coding like alias/functions ? Currently
> triggers must refer to an existing compiled class - the alternative to
> provide the java code in the trigger creation statement would really be a
> plus.
>
> As an alias gets implicitly the connection, a trigger method would in
> addition receive the old and new rows.
>
>
> On Monday, January 16, 2017 at 1:56:20 PM UTC-5, Noel Grandin wrote:
>
> we have triggers, we just don't have triggers implemented in some embedded
> SQL mini-language.
>
> http://h2database.com/html/grammar.html#create_trigger
>
> I don't think this is likely to happen any time soon, since I consider the
> current solution adequate, and I don't see the point in creating a
> half-baked trigger language when we can already use a full-featured
> language like Java.
> ​
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to h2-database+unsubscr...@googlegroups.com.
> To post to this group, send email to h2-database@googlegroups.com.
> Visit this group at https://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.