Re: [WebDNA] Repeated Task [reworking a DB)
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 112107
interpreted = N
texte = I have a client that asks for things that sometimes take down the =server. I use max=3Dx to determine what the limit is so I can at least =play around with just the first 25 records until I finalize the job.You could use max=3D500 (whatever you can get away with), and use =shownext links to step through the chunks until you get them all done. I =guess you'd manually sit there and click to the next page each time, or =I guess you could set up a redirect.TerryOn Feb 11, 2015, at 9:24 AM, Palle Bo Nielsen
=wrote:> Hi all>=20> Any suggestions on how to take the value of FIELD A and change the =value and replace to into FIELD, when>=20> - when FIELD A is a CART value which can be between 13 and 18 chars> - and the result must end up being the the first 13 chars> - and the DB consist of 1 million rows>=20> I have no problem in identifying FIELD A and changing it to the new =VALUE in FIELD B nor replacing it into the database. My problem is that =if I just kick off the script it take down the server. So it needs to =take it in chunks of ex. 500 unit.>=20> So how to repeat? Reedit to same page or? Any other good ideas?>=20> /Palle---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
I have a client that asks for things that sometimes take down the =server. I use max=3Dx to determine what the limit is so I can at least =play around with just the first 25 records until I finalize the job.You could use max=3D500 (whatever you can get away with), and use =shownext links to step through the chunks until you get them all done. I =guess you'd manually sit there and click to the next page each time, or =I guess you could set up a redirect.TerryOn Feb 11, 2015, at 9:24 AM, Palle Bo Nielsen =wrote:> Hi all>=20> Any suggestions on how to take the value of FIELD A and change the =value and replace to into FIELD, when>=20> - when FIELD A is a CART value which can be between 13 and 18 chars> - and the result must end up being the the first 13 chars> - and the DB consist of 1 million rows>=20> I have no problem in identifying FIELD A and changing it to the new =VALUE in FIELD B nor replacing it into the database. My problem is that =if I just kick off the script it take down the server. So it needs to =take it in chunks of ex. 500 unit.>=20> So how to repeat? Reedit to same page or? Any other good ideas?>=20> /Palle---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
Terry Wilson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCatalog vs. Cold Fusion (1998)
randomness (1997)
RE: Error: template (1997)
Weeks starting on Mondays (1998)
Example Search Form (1997)
Help formatting search results w/ table (1997)
carriage returns in data (1997)
[WebDNA] Hosting for a customer of mine (2012)
Banner Sleuth Updater (1999)
No luck with taxes (1997)
WSDL Wizard (2003)
many-to-one problem (1998)
New syntax feedback for 4.0 (2000)
[WebDNA] TcpConnect Help (2011)
Emailer help....! (1997)
Updating product information (2002)
Logging purchases (1997)
WebCat2 beta 11 - new prefs ... (1997)
$Replace with [founditems] (1997)
no emailfolder errors? (2000)