I found the difference in the code (it was fun, like a sesame street excersise).
The first code has this line for the Footprint record:
<cfset Footprint = Event_Photos_Record.getFootprintsIterator().add()/>
The second code has this:<cfset Footprints_Record = Reactor.createRecord("Footprints") />
And the first code has this line for the Footprint_Photo record:
<cfset R_Footprint_Photo = Event_Photos_Record.getR_Footprint_PhotoIterator().add()/>
And the second code has this:<cfset R_Footprint_Photo_Record =
Reactor.createRecord("R_Footprint_Photo") />
On 4/20/06, Doug Hughes <[EMAIL PROTECTED]> wrote:
I still don't know what you're doing. I'm not seeing those sorts of times.
Without more info I can't help you.
Doug
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf
Of Daryl
Sent: Thursday, April 20, 2006 9:49 PM
To: [email protected]
Subject: Re: [Reactor For CF] Using iterator method(s) to create/insert a
record into a table doubles execution time?
Production mode and all debugging turned off for the 427ms /267 ms times.
the earlier, higher times (2Kms/1K ms) were in production mode with
debugging on.
On 4/20/06, Doug Hughes < [EMAIL PROTECTED]> wrote:
>
>
>
> One other thing - are you testing the time in production mode? If you're
in
> development it'll probably be pretty slow for you. Production caches a
lot
> more data and, in general, is much faster.
>
>
>
>
> Doug
>
>
>
> ________________________________
>
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf
> Of Daryl
> Sent: Thursday, April 20, 2006 9:06 PM
> To: [email protected]
> Subject: Re: [Reactor For CF] Using iterator method(s) to create/insert a
> record into a table doubles execution time?
>
>
>
>
>
>
>
> On 4/20/06, Doug Hughes <[EMAIL PROTECTED]> wrote:
> > Can you clarify this?
> >
> > Doug
> >
> > relative speeds are about the same without debugging:
> >
> there's more code in the cfcs than these calls, but these calls are the
> only difference between the two cfcs:
>
> 267 milliseconds not using iterator add()
>
>
> <!----------------------------
> ==============================
> EVENT PHOTOS INSERT
> ==============================
> ----------------------------->
> <!--- create a record --->
> <cfset Event_Photos_Record =
> Reactor.createRecord("Event_Photos") />
>
> <!--- populate the new record --->
>
> <CFSET sScheduleID = LEFT( arguments.Photo_ID,5)>
> <CFSET sCameraID = MID(arguments.Photo_ID,6,3)>
> <CFSET sSequence_Num = RIGHT(arguments.Photo_ID,5)>
>
> <cfset this_path = "/photos/" & sScheduleID & "/" & sCameraID
&
> "/" & sSequence_Num & ".jpg">
> <cfset
> Event_Photos_Record.SETEVENT_PHOTO_ID("#arguments.PHOTO_ID#")>
> <cfset
> Event_Photos_Record.SETPATH("#trim(this_path)#")>
> <cfset
> Event_Photos_Record.SETPHOTO_ENVIRONMENT_ID("#arguments.WATERMARK_ID#")>
> <cfset
> Event_Photos_Record.SETR_ELAT_ID("#Photo_Loc_R_ELAT_ID#")
> />
> <cfset
> Event_Photos_Record.SETEVENT_DAY_ID("#arguments.SUB_EVENT_DATE_ID#")
> />
> <cfset
> Event_Photos_Record.SETCLIENT_LICENSE_ID("#efn_client_licenseID#")
> />
> <cfset
> Event_Photos_Record.SETSYSTEM_ID("#arguments.CAMERA_ID)#")>
> <cfset
> Event_Photos_Record.SETSEQUENCE_ID("#arguments.sSequence_Num#")>
> <cfset
> Event_Photos_Record.SETCREATE_DTM(#arguments.CREATE_DTM#)
> />
> <cfset
> Event_Photos_Record.SETSAMPLE_FLAG("0")>
>
> <!--- save the record --->
> <cfset Event_Photos_Record.save() />
>
> <cfset inserted_id_event_photos =
> Event_Photos_Record.GETEVENT_PHOTO_ID()>
>
>
>
> <!----------------------------
> ==============================
> FOOTPRINTS INSERT
> ==============================
> ----------------------------->
>
> <!--- create a record --->
> <cfset Footprints_Record = Reactor.createRecord("Footprints")
> />
>
> <!--- populate the new record --->
> <cfset
> Footprints_Record.SETEVENT_TOKEN_ID("#arguments.BARCODE_ID#")>
> <cfset
> Footprints_Record.SETR_ELAT_ID("#Photo_Loc_R_ELAT_ID)#") />
> <cfset
> Footprints_Record.SETEVENT_DAY_ID("#arguments.SUB_EVENT_DATE_ID#")
> />
> <cfset
> Footprints_Record.SETCLIENT_LICENSE_ID("#efn_client_licenseID)#")
> />
> <cfset
> Footprints_Record.SETSYSTEM_ID("#arguments.CAMERA_ID#")>
> <cfset
> Footprints_Record.SETCREATE_DTM("#arguments.CREATE_DTM#")
> />
> <cfset Footprints_Record.SETSAMPLE_FLAG("0")>
> <cfset Footprints_Record.SETIP_ADDRESS("")>
>
> <!--- save the record --->
> <cfset Footprints_Record.save() />
>
> <Cfset inserted_id_footprints_loc =
> Footprints_Record.GETFOOTPRINT_ID()>
> <!--- Footprints_ID (loc):
> <cfoutput>#inserted_id_footprints_loc#</cfoutput><br> --->
>
> <!------------------------
> ==========================
> R_FOOTPRINT_PHOTO INSERT
> ==========================
> ------------------------>
>
> <!--- create a Record --->
> <cfset R_Footprint_Photo_Record =
> Reactor.createRecord("R_Footprint_Photo") />
>
> <!--- populate the new record --->
> <cfset
> R_Footprint_Photo_Record.SETEVENT_PHOTO_ID("#inserted_id_event_photos#")
> />
> <cfset
> R_Footprint_Photo_Record.SETFOOTPRINT_ID("#inserted_id_footprints_loc#")
> />
> <!--- save the record --->
> <cfset R_Footprint_Photo_Record.save() />
>
>
> 426 milliseconds using the iterator calls
>
> the iterator is based on a linking table relationship
>
>
> <!----------------------------
> ==============================
> EVENT PHOTOS INSERT
> ==============================
> ----------------------------->
> <!--- create a record --->
> <cfset Event_Photos_Record =
> Reactor.createRecord("Event_Photos") />
>
>
> <!--- populate the new record --->
>
> <CFSET sScheduleID = LEFT(arguments.Photo_ID,5)>
> <CFSET sCameraID = MID(arguments.Photo_ID,6,3)>
> <CFSET sSequence_Num = RIGHT( arguments.Photo_ID,5)>
>
> <cfset this_path = "/photos/" & sScheduleID & "/" & sCameraID
&
> "/" & sSequence_Num & ".jpg">
> <cfset
> Event_Photos_Record.SETEVENT_PHOTO_ID("#arguments.PHOTO_ID#">
> <cfset
> Event_Photos_Record.SETPATH("#trim(this_path)#")>
> <cfset
> Event_Photos_Record.SETPHOTO_ENVIRONMENT_ID("#arguments.WATERMARK_ID#")>
> <cfset
> Event_Photos_Record.SETR_ELAT_ID("#Photo_Loc_R_ELAT_ID#")
> />
> <cfset
> Event_Photos_Record.SETEVENT_DAY_ID("#arguments.SUB_EVENT_DATE_ID#")
> />
> <cfset
> Event_Photos_Record.SETCLIENT_LICENSE_ID("#efn_client_licenseID#")
> />
> <cfset
> Event_Photos_Record.SETSYSTEM_ID("#arguments.CAMERA_ID#")>
> <cfset
> Event_Photos_Record.SETSEQUENCE_ID("#arguments.sSequence_Num#")>
> <cfset
> Event_Photos_Record.SETCREATE_DTM(#arguments.CREATE_DTM#)
> />
> <cfset
> Event_Photos_Record.SETSAMPLE_FLAG("0")>
>
> <!--- save the record --->
> <cfset Event_Photos_Record.save() />
>
> <cfset inserted_id_event_photos =
> Event_Photos_Record.GETEVENT_PHOTO_ID()>
>
>
>
>
> <!----------------------------
> ==============================
> FOOTPRINTS INSERT
> ==============================
> ----------------------------->
>
> <!--- <cfset FootprintsItArray =
> Event_Photos_Record.GETFOOTPRINTSITERATOR().GetArray()/>
> --->
> <cfset Footprint =
> Event_Photos_Record.getFootprintsIterator().add()/>
>
>
> <!--- populate the new record --->
> <cfset Footprint.SETEVENT_TOKEN_ID("#arguments.BARCODE_ID#")>
> <cfset Footprint.SETR_ELAT_ID("#Photo_Loc_R_ELAT_ID#") />
> <cfset
> Footprint.SETEVENT_DAY_ID ("#arguments.SUB_EVENT_DATE_ID#")
> />
> <cfset
Footprint.SETCLIENT_LICENSE_ID("#efn_client_licenseID#")
> />
> <cfset Footprint.SETSYSTEM_ID ("#arguments.CAMERA_ID#")>
> <cfset Footprint.SETCREATE_DTM("#arguments.CREATE_DTM#") />
> <cfset Footprint.SETSAMPLE_FLAG("0")>
> <cfset Footprint.SETIP_ADDRESS("")>
>
> <!--- save the record --->
> <cfset Footprint.save() />
>
> <Cfset inserted_id_footprints_loc =
> Footprint.GETFOOTPRINT_ID()>
>
>
> <!------------------------
> ==========================
> R_FOOTPRINT_PHOTO INSERT
> ==========================
> ------------------------>
>
> <!--- create a Record --->
> <cfset R_Footprint_Photo =
> Event_Photos_Record.getR_Footprint_PhotoIterator().add()/>
>
> <!--- populate the new record --->
> <cfset
> R_Footprint_Photo.SETEVENT_PHOTO_ID("#inserted_id_event_photos#")
> />
> <cfset
> R_Footprint_Photo.SETFOOTPRINT_ID("#inserted_id_footprints_loc#")
> />
> <!--- save the record --->
> <cfset R_Footprint_Photo.save() /> -- 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/
-- 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/
--
Chris Phillips
www.dealerpeak.com
Senior Application Developer -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
