I am reading the manual, too. What is the difference between LINQ (Query.All<t>), Compiled (Query.Execute), and Future Queries? When is each appropriate? What are the consequences (e.g. performance) of each? Updated at 13.01.2010 3:43:13I asked this question after reading the first 2-3 pages... but the differences become very obvious as you continue reading. Sorry for being lazy =) For others (as far as I understand): 1) Regularly query is executed on enumeration. 2) Compiled query is similar to a stored procedure... you can execute multiple queries that have different parameter values by reusing the compiled query (so that DO doesn't have to translate/compile your query every time). 3) Future queries allow you to create X number of queries... then have them executed in one batch (i.e. one round trip to DB). Almost done reading manual... great job guys. This thread was imported from our support forum. The original discussion may contain more detailed answer. |
I have a tricky, but fast answer: I sent you the source today, so I can try to ask you to search for "ExecuteFuture" in our test projects :) The example form Manual project: http://goo.gl/0iMh |
Yes, exactly - thanks for publishing a nice summary ;)
Hi,
I don't seem to be able to find any examples on how to pass parameters to Future Queries. Can someone help me here please?
Regards