I can't put this in strong enough terms: don't do that! Why do you need these as records? Why do you need 400 questions all at once?
Only convert what you need to :) Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Lynch Sent: Wednesday, August 30, 2006 11:44 AM To: [email protected] Subject: [Reactor for CF] Iterator performance question I am encountering some slow processing/request time-outs when trying to do any instantiation of an object's children (400 ish child objects , each has additional child objects of their own) and I am hoping someone else out there has seen this too. Here is the scenario: Company object is instantiated in the session scope. A Company has Many Questions (via a linked relational table "CompanyQuestions") (There happen to be 448 Questions associated with this Company.) Each Question has a couple has One relationships of its own. When I do a getQuestionIterator().getArray() I get a request timeout (obviously, the same thing happens when I loop over the iterator to access each Question object)... note: I changed the request timeout to 180 seconds just to see if it could complete within that time-frame, it still timed out. When I do a getQuery() it runs fine and returns the record-set as it should. Reactor config is set to production mode... Database is MSSQL 2000... Any ideas on ways to improve this performance? I need to get to the Question's children as part of the process I am working on, and I would like to be able to utilize the Question iterator if possible. Thanks in advance, Aaron Lynch www.AaronJLynch.com -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
