I suspect I've hit a problem where korma and h2 don't like each other. Korma likes to group "join" clauses with parentheses (via korma.sql.utils/left-assoc), but the parentheses appear to prevent h2 from picking appropriate indexes, so the performance is unusable. Removing the parentheses fixes the query.
I'm not very excited about manipulating raw sql strings, or patching & rebuilding korma for this case. Are there any good ways to work around this? Or good alternatives to korma? If there are no good options, can I monkey patch it? And if so, how would I do that? I.e. can I replace a function in korma.sql.engine such that when I invoke korma it will use the new function? -- -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members are moderated - please be patient with your first post. To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/clojure?hl=en --- You received this message because you are subscribed to the Google Groups "Clojure" group. To unsubscribe from this group and stop receiving emails from it, send an email to clojure+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.