Re: performance and CFC gateways

exactamundo! Going with XML, generated in the SQL even, returned to the view. Use the 'bean force' for manipulating the data. shazzam! DK On 8/29/06, Kris Jones <[EMAIL PROTECTED]> wrote: > > > So, in the gateway I have a method that > > grabs all 1100 rows, loops over them creating a bean fr

RE: performance and CFC gateways

The next step I would do would be to add cfflush to the mix. Then append periods (.) and some other output indicators throughout your loops. See if the process experiences a slowdown at any point. Terrence Ryan Senior Systems Programmer Wharton Computing and Information Technology E-

Re: performance and CFC gateways

> So, in the gateway I have a method that > grabs all 1100 rows, loops over them creating a bean from the row, and > adding the bean to a array which is eventually returned. Performance > absolutely sucks. It takes about 15 seconds to do this. Any ideas on how > to speed this up? Unless you are

Re: performance and CFC gateways

arrayresize didn't matter really, but a good point for sure. With debugging on, times increased by about 4 to 5 fold, already caught that one! danke DK On 8/29/06, Ryan, Terrence <[EMAIL PROTECTED]> wrote: > > I have a feeling that it will take a couple passes to improve the > performance of th

RE: performance and CFC gateways

I have a feeling that it will take a couple passes to improve the performance of the operation. Are you using ArrayResize to allocate the size of the array before hand? This helps the performance of Large Arrays. Are you a CFC function to assign the results to a bean, and repeating all 1

Re: performance and CFC gateways

obj = createObject( ) obj.setfoo(qRead.foo) obj.setgoo(qRead.goo) .. .. .. then array append. DK On 8/29/06, Peterson, Chris <[EMAIL PROTECTED]> wrote: > > Well, how are you assigning the variables into the bean, using > evaluate() or query[column] notation? Evaluate could be killing your > spee

RE: performance and CFC gateways

I think we've decided that Evaluate no longer has a noticeable performance hit. Russ > -Original Message- > From: Peterson, Chris [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 29, 2006 1:33 PM > To: CF-Talk > Subject: RE: performance and CFC gateways > > W

RE: performance and CFC gateways

Well, how are you assigning the variables into the bean, using evaluate() or query[column] notation? Evaluate could be killing your speed possibly? Chris -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 29, 2006 1:18 PM To: CF-Talk Subject: perfor