Re: [WebDNA] A new popuated field to a DB with 700.000 records

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 104089
interpreted = N
texte = but is [index] avail. in [replacefounditems]? I assume we need to be inside [founditems] to get [index]. no? -G On Dec 2, 2009, at 2:55 PM, Kenneth Grome wrote: >> it would be nice to get it done in one process. > > If webdna is dying when you use replacefounditems like this: > > [search db=l4.db&nel4_statusdata=dummy&asl4_serialsort=1] > [replacefoundItems]l4_index=[index][/replacefoundItems] > [/search] > > ... then you might try this single process: > > [loop start=1&end=7000] > [waitforfile file=fileNeverExists&timeout=5] > [search db=l4.db&eql4_index=[blank]&asl4_serialsort=1&max=100] > [replacefounditems]l4_index=[index][/replacefounditems] > [/search] > [/waitforfile] > [/loop] > > Before you run something like this you should test the code inside > the waitforfile context to make sure a single iteration doesn't take > more than 5 seconds to complete. I would feel safer if it takes > less than 1 second. > > It should take about 9.7 hours for all 7000 iterations to finish. > > Sincerely, > Kenneth Grome > www.KenGrome.com > > > > > > > --------------------------------------------------------- > 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 > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 ------------ Govinda govinda.webdnatalk@gmail.com Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] A new popuated field to a DB with 700.000 records (christophe.billiottet@webdna.us 2009)
  2. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Kenneth Grome 2009)
  3. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Govinda 2009)
  4. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Kenneth Grome 2009)
  5. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Govinda 2009)
  6. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Palle Bo Nielsen 2009)
  7. Re: [WebDNA] A new popuated field to a DB with 700.000 records (christophe.billiottet@webdna.us 2009)
  8. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Palle Bo Nielsen 2009)
  9. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Palle Bo Nielsen 2009)
  10. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Donovan 2009)
  11. Re: [WebDNA] A new popuated field to a DB with 700.000 records (chas conquest 2009)
  12. Re: [WebDNA] A new popuated field to a DB with 700.000 records (christophe.billiottet@webdna.us 2009)
  13. Re: [WebDNA] A new popuated field to a DB with 700.000 records (christophe.billiottet@webdna.us 2009)
  14. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Donovan Brooke 2009)
  15. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Kenneth Grome 2009)
  16. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Dan Strong 2009)
  17. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Kenneth Grome 2009)
  18. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Govinda 2009)
  19. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Kenneth Grome 2009)
  20. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Marc Thompson 2009)
  21. Re: [WebDNA] A new popuated field to a DB with 700.000 records (christophe.billiottet@webdna.us 2009)
  22. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Palle Bo Nielsen 2009)
  23. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Dan Strong 2009)
  24. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Palle Bo Nielsen 2009)
  25. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Palle Bo Nielsen 2009)
  26. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Dan Strong 2009)
  27. Re: [WebDNA] A new popuated field to a DB with 700.000 records (Govinda 2009)
  28. [WebDNA] A new popuated field to a DB with 700.000 records (Palle Bo Nielsen 2009)
but is [index] avail. in [replacefounditems]? I assume we need to be inside [founditems] to get [index]. no? -G On Dec 2, 2009, at 2:55 PM, Kenneth Grome wrote: >> it would be nice to get it done in one process. > > If webdna is dying when you use replacefounditems like this: > > [search db=l4.db&nel4_statusdata=dummy&asl4_serialsort=1] > [replacefounditems]l4_index=[index][/replacefoundItems] > [/search] > > ... then you might try this single process: > > [loop start=1&end=7000] > [waitforfile file=fileNeverExists&timeout=5] > [search db=l4.db&eql4_index=[blank]&asl4_serialsort=1&max=100] > [replacefounditems]l4_index=[index][/replacefounditems] > [/search] > [/waitforfile] > [/loop] > > Before you run something like this you should test the code inside > the waitforfile context to make sure a single iteration doesn't take > more than 5 seconds to complete. I would feel safer if it takes > less than 1 second. > > It should take about 9.7 hours for all 7000 iterations to finish. > > Sincerely, > Kenneth Grome > www.KenGrome.com > > > > > > > --------------------------------------------------------- > 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 > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 ------------ Govinda govinda.webdnatalk@gmail.com Govinda

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:

[AppendFile] problem (WebCat2b13 Mac .acgi) (1997) 2 databases (1997) [OT] Dedicated Image Uploader/Server [/OT] (2003) how to do [search] params on the fly? (2004) Questions To Answer (1997) Format question WC Mac f3 (1997) Help! WebCat2 bug (1997) The last version of webcat (1999) Replace Statement (1997) Incrementing a number (1998) bug in [SendMail] (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Date Range Issue (2006) Configuring E-mail (1997) [SearchString] problem with [search] context (1997) [WebDNA] Debian Lenny, Lighttpd and WebDNA FastCGI ... (2010) .htaccess to make WebDNA serve HTML (2007) auto enter dates (1998) Re:no [search] with NT (1997) Here's how to kill a Butler Database. (1997)