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. Terry On 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. Terry On 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:
[WebDNA] General email error -1 (WebDNA 7) (2012)
Page Counters? (1997)
quitting (1997)
[include ...] behavior (1997)
Using Plug-In while running 1.6.1 (1997)
Error handling for accountNum (1997)
setting a cookie for the whole server (2004)
rotating thumbnails (1997)
WebCat2 - Getting to the browser's username/password data (1997)
(2000)
Signal Raised (1997)
Help name our technology! (1997)
show me your store ! (2003)
[SHOWIF AND/OR] (1997)
[BULK] [WebDNA] [BULK] db-temp files (2011)
shipcost (1997)
Date Sorting (1997)
Adding multiple items to Cart at one time, & append context problem (1998)
Include Files (1998)
Linebreaks and [writefile] (2003)