While he didn't stick the bottle in your mouth for you, al least he did tell
you to take your hand off the burner.
If importing the dbase db into Oracle, then doing the compare in the db with
sql is not an option, and doing the compare with another program written in
VB or Java or something isn't either. I'd say explore using flags to signify
a new record in the new db...
Every bit of your code is doable in Oracle though...just get the data into
Oracle first.
jon
----- Original Message -----
From: "Art Broussard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 11:53 AM
Subject: Re: What else can I say but HELP!!!!
> Thanks for not helping.
>
>
> > don't use CF...
> >
> > -----Original Message-----
> > From: Art Broussard [mailto:[EMAIL PROTECTED]]
> > Sent: 13 February 2001 15:57
> > To: CF-Talk
> > Subject: What else can I say but HELP!!!!
> >
> >
> > I am doing a query to get all the records, 43224, from a dbase4 database
> > that was created from a tab delemeted file.
> > I then check each record to see if it is in an Oracle table with 52,000
> > records and still growing.
> > If it is then update that record.
> > If not, insert that record.
> >
> > So far it takes about 10 min just to get through the first 500
> > inserts/updates.
> > Using my bad math skills, it should take over 12 hours to do this!
> >
> > Any one have any ideas on how to reduce the time it takes to do all of
> this?
> >
> > Phillip
> >
> > Here is my code.
> >
> > <cfquery name="get" datasource="POUTDOORS_DBF">
> > select * from poutdoors_dbf
> > </cfquery>
> >
> > <cfoutput>Total records from dbase4:
> <b>#get.RecordCount#</b></cfoutput><P>
> > <ol start="1">
> > <cfoutput>
> > <cfloop query="get" startrow="1" endrow="#get.RecordCount#">
> > <cfquery name="check" datasource="#application.datasource#">
> > select text_id, proddate from prodheader
> > where itemno2 = '#itemno2#' and
> > itemno3 = '#itemno3#' and
> > itemno4 = '#itemno4#'
> > </cfquery>
> >
> > <cfif check.RecordCount is "0">
> >
> > <cfquery name="put" datasource="#application.datasource#">
> > insert into prodheader
> > values(prodheaderID.NextVal,
> > 'Off',
> > '#DateFormat(Now(), "dd-mmm-yyyy")#',
> > 0,
> > '#itemno2#',
> > '#itemno3#',
> > '#itemno4#',
> > #dept#,
> > #subdept#,
> > #class#,
> > #subclass#,
> > #text_id#,
> > '#RTrim(header)#',
> > '#RTrim(status)#')
> > </cfquery>
> >
> > </cfif>
> > <cfif check.RecordCount gt "0" and check.proddate is not
> > "#DateFormat(Now(), "dd-mmm-yyyy")#">
> >
> > <cfquery name="add" datasource="#application.datasource#">
> > update prodheader
> > set proddate = '#DateFormat(Now(), "dd-mmm-yyyy")#',
> > text_id = #text_id#,
> > header = '#RTrim(header)#',
> > bpstatus = '#RTrim(status)#'
> > where itemno2 = '#itemno2#' and
> > itemno3 = '#itemno3#' and
> > itemno4 = '#itemno4#'
> > </cfquery>
> >
> > </cfif>
> > <li>RECORD<br>
> > </cfloop>
> > </cfoutput>
> > </ol>
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
