In several threads the connection option LAZY_QUERY_EXECUTION=1 has been mentioned, mostly as an option to improve performance with large result sets.
I have been looking into the documentation but can not find any more information about this option. I do understand what the option is about globally but I would like some more details about: - how does this affect query speed? Any scenario's where this option may be much quicker/slower than the default mode? - how does this affect memory use? - does this have any positive/negative influence on concurrency? - are there restrictions to using this option? For example: can I have hundreds of connections at the same time using this option? - can this be considered stable and fit for production? The release notes say it is no longer "experimental" but can I interpret that as it being as stable as the default mode? Thanks in advance for any information. -- 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.