Does Sequel support sending multiple select statements in a single batch with a deferred execution mechanism such as the one detailed here:http://blog.andrewawhitaker.com/blog/2014/06/28/queryover-series-part-5-materializing-results/ and here:http://ayende.com/blog/3979/nhibernate-futures (Note that both are the same, one just uses a newer api than the other.)?
The idea here is that you can defer the transmission of SQL to the database is such a way that only one call is ever made to the database even if you are retrieving multiple distinct datasets. This is extremely handy when trying to build complex objects with association fields and you want to pull in all of the child objects based on the parent table. Put another way given a set X sets A,B,C all use X in a subquery of the form: select * from (A, B, or C) where (A,B,or C).fk in(select X.pk from X) I'm using this kind of technique to reduce the number of SQL queries from over 2k to a value in double digits if not less at my job, with what I hope will remain a single trip to the database to grab everything. -- You received this message because you are subscribed to the Google Groups "sequel-talk" 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 http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
