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 -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
