> Hmm, it's possible, do you get OutOfMemory errors in the logs? Haven't checked yet....and actually have been killing the threads via Fusion Reactor when they got up around 300,000 ms!! ;-)
> > That said, I would warn you off using QoQ / Queries (or a web application > under load) to generate 20K recordsets, it's a terribly waste of memory, > network and resources. As I'm finding ;-) > > What are the business requirements for these recordsets? Is is reporting? Yes...reporting. I've actually alredy abandonded this approach for another that will be much simpler to maintain and fatser to run, but I'd still like to know if there are these limitations in QofQs or if it may be something else....looks like there are those limitations. Thanks Neil Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
