Re: [Reactor For CF] Using iterator method(s) to create/insert a record into a table doubles execution time?

[Jared Rypka-Hauer]

Daryl, The wrap made that almost entirely unreadable... Can you save the view as HTML and send it as an attachment or something? Thanks, J ------------------------------------------------ Jared C. Rypka-Hauer Continuum Media Group LLC http://www.web-relevant.com Member, Team Macromedia - ColdFusion "That which does not kill me makes me stranger." - Yonah Schmeidler On Apr 20, 2006, at 6:42 PM, Daryl wrote: using the iterator methods instead of the separate record instances doubled the execution time of the page: Prior to using iterator add() method to create related records: 1281 ms  1281 ms  1   After changing to using the iterator add() method for doing inserts/record creation: 2347 ms  2347 ms some of the execution times (the highest few): 877 ms  439 ms  2  CFC[ /var/www/html/reactor/iterator/iterator.cfc | add() ] 439 ms 439 ms 1 CFC[ /var/www/html/reactor/iterator/iterator.cfc | add() ] 374 ms 374 ms 1 CFC[ /var/www/html/ajax/Gateway/R_Footprint_PhotoGatewaymysql4.cfc | getByQuery(CFC: reactor.query.query, false) ] from /var/www/html/reactor/iterator/iterator.cfc 310 ms 310 ms 1 CFC[ /var/www/html/ajax/Record/Event_PhotosRecordmysql4.cfc | save() ] from /var/www/html/ajax/photo_save.cfm 307 ms 307 ms 1 CFC[ /var/www/html/ajax/Dao/Event_PhotosDaomysql4.cfc | save(CFC: ajax.To.Event_PhotosTomysql4) ] from /var/www/html/ajax/Record/Event_PhotosRecordmysql4.cfc 267 ms 267 ms 1 CFC[ /var/www/html/ajax/Record/R_Footprint_PhotoRecordmysql4.cfc | save() ] from /var/www/html/ajax/photo_save.cfm 263 ms 263 ms 1 CFC[ /var/www/html/ajax/Dao/R_Footprint_PhotoDaomysql4.cfc | save(CFC: ajax.To.R_Footprint_PhotoTomysql4) ] from /var/www/html/ajax/Record/R_Footprint_PhotoRecordmysql4.cfc On 4/20/06, Daryl <[EMAIL PROTECTED]> wrote: whoops, found it: "Now, on to the more-fun details.  Let's say you have a user that hasMany addresses.  (user.userId = address.userId).  The iterator object now has add and delete methods.  Add will add an object into the iterator and return it.  It will not save the record till you call save on the record or save on the iterator (another new method!).  " -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/