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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
