Lookup Plus reuse of queries
22 views
Skip to first unread message
tad.d...@gmail.com
Dec 9, 2015, 11:11:52 AM12/9/15
to COZYROC
If two lookups in a Lookup Plus component use the same SQL query as a source, will the result set be reused or loaded twice?
Specifically, I have a query that is rather slow to execute. One lookup keys on Column A and returns Column B. The second keys on Column A and returns Column C.
If there is reuse, then "SELECT A, B, C FROM MYTABLE" for both seems more memory efficient. If there isn't, then splitting it into "SELECT A,B FROM MYTABLE" and "SELECT A,C FROM MYTABLE" seems more efficient.
Specifically, I have a query that is rather slow to execute. One lookup keys on Column A and returns Column B. The second keys on Column A and returns Column C.
If there is reuse, then "SELECT A, B, C FROM MYTABLE" for both seems more memory efficient. If there isn't, then splitting it into "SELECT A,B FROM MYTABLE" and "SELECT A,C FROM MYTABLE" seems more efficient.
Ivan Peev
Dec 9, 2015, 11:21:55 AM12/9/15
to COZYROC
Hi,
There is no result set reuse in the Lookup Plus.
Reply all
Reply to author
Forward
0 new messages