I agree... good idea Tony... I am going to try my big batch of 20-30k
items tonight and compare the run times :)
-paris
-----Original Message-----
From: "Warrick, Mark" <[EMAIL PROTECTED]>
Date: Sat, 26 May 2001 22:40:18 -0700
Subject: Re: bulk updating database from txt file
> That's one of the brightest ideas I've heard about ColdFusion
> programming.
> Good job, Tony.
>
> ---mark
>
> ----- Original Message -----
> From: "Tony Schreiber" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, May 26, 2001 7:48 PM
> Subject: Re: bulk updating database from txt file
>
>
> > I have a cf template (well a couple) that actively (via http)
> solicit
> > prices from websites. I had one going that did 300,000 price
> updates over
> > several days.
> >
> > The best way I found to run this template was via the command line,
> ie:
> >
> > e:\cfusion\bin\cfml.exe e:\webroot\scan\pricereport.cfm
> >
> > No request timeouts, no hung browser windows...
> >
> > > I have a largish access database (30,000 records) which needs to
> be
> updated
> > > from a comma delimited text file.
> > > There will be some updated records and some new records.
> > > I am not sure how to begin with this
> > > My worries are
> > > how do I do an update loop when some records will have to be
> inserted
> and
> > > some updated.
> > > Also this would presumably take a long time to do - how do I
> handle this
> > >
> > > Any suggestions welcome (assume I am a bear with very little
> brain) or
> any
> > > tutorials on this sort of thing.
> > >
> > > many thanks
> > >
> > > Seamus
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
