Re: [WebDNA] Repeated Task [reworking a DB)
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 112108
interpreted = N
texte = I am just looking for a best practise way of doing it, since I am not = looking for a manual shownext task (=E2=80=9Czzzzzzz=E2=80=9D)=E2=80=A6 Maybe a redirect is the solution, but won=E2=80=99t it give me other = problems? Or maybe still adding to the memory challenge=E2=80=A6.? /Palle > On 11/02/2015, at 18.39, Terry Wilson
wrote: >=20 > 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. >=20 > 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. >=20 > Terry >=20 > On Feb 11, 2015, at 9:24 AM, Palle Bo Nielsen = wrote: >=20 >> 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 >=20 > --------------------------------------------------------- > 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 am just looking for a best practise way of doing it, since I am not = looking for a manual shownext task (=E2=80=9Czzzzzzz=E2=80=9D)=E2=80=A6 Maybe a redirect is the solution, but won=E2=80=99t it give me other = problems? Or maybe still adding to the memory challenge=E2=80=A6.? /Palle > On 11/02/2015, at 18.39, Terry Wilson wrote: >=20 > 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. >=20 > 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. >=20 > Terry >=20 > On Feb 11, 2015, at 9:24 AM, Palle Bo Nielsen = wrote: >=20 >> 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 >=20 > --------------------------------------------------------- > 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
Palle Bo Nielsen
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:
This list needs a digest: rant, rave... (1997)
Add message to Order (1997)
Running _every_ page through WebCat ? (1997)
Running 2 two WebCatalog.acgi's (1996)
Re:Running 2 two WebCatalog.acgi's (1996)
Access Denied! But why? (1997)
Somewhat OT: IE issues (2002)
autosensing lanague selection (1997)
Bulk Email >>>>Any ideas? (2001)
Error: this shopping cart has already been submittedm (2004)
[table] tag (2003)
WebCatb15 Mac CGI -- [purchase] (1997)
Header Problems (1998)
weirdness in the error log (1998)
Passing Variables to a [shell scriptid=123][/shell] context (2004)
Alternating colors (1997)
PDF mailing labels (2000)
WebCatalog Plug-in for Webstar. (1997)
Re:Hideif / Showif (1998)
Forms Search Questions (1997)