[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Nested SQL performance question

defintely the latter

________________________________

From: sqr-users-bounces+lroux=syr.edu@sqrug.org on behalf of Randell, Tom
Sent: Wed 4/18/2007 5:17 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Nested SQL performance question



Hi,

            Does anyone know how SQR processes two nested begin-select
statements?  Does the Portal server run the outmost query to completion
(storing the results on the Portal server) and then call the nested
procedure for each row in the outermost query's result set?  Or does the
Portal open two cursors to the database at the same time and call the
innermost select for each row returned in the outermost select?  Any
ideas?



Thanks Tom

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users