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=A6Maybe 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:

Re: [WebDNA] Repeated Task [reworking a DB) (Stuart Tremain 2015)
Re: [WebDNA] Repeated Task [reworking a DB) (Kenneth Grome 2015)
Re: [WebDNA] Repeated Task [reworking a DB) (Palle Bo Nielsen 2015)
Re: [WebDNA] Repeated Task [reworking a DB) (Kenneth Grome 2015)
Re: [WebDNA] Repeated Task [reworking a DB) (Palle Bo Nielsen 2015)
Re: [WebDNA] Repeated Task [reworking a DB) (Terry Wilson 2015)
[WebDNA] Repeated Task [reworking a DB) (Palle Bo Nielsen 2015)

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=A6Maybe 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!

Re: [WebDNA] Repeated Task [reworking a DB)

2015

Top Articles:

Related Readings: