RE: XPS questions

For anyone interested the following is what I think I have discovered on the topic. >>Question 1. >>Is the result set for a particular query just stored in a temp table > >in the connection co-server until all the data is finally retrieved? The full return set is not stored anywhere, the connection co-server just funnels the data it recieves from the other co-servers as well as from itself back to the client. >>Question 2:. ><snip> >>It seems to me that there needs to be a step 3.5, something like: coservers >>send data back to the connection coserver who finishes the join, sort, >>group by, ... operations. or coservers then pull data from the remote >>co-servers finishing the join operation and then pass the data back to the >>connection server to finish sort, group by operations... This data is processed in parallel on the separate co-servers, if they require information from other coservers they get it. If I wasnt clear, or am wrong I would be happy to hear about it, Will ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------