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 = 104088
interpreted = N
texte = > 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 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)
> 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 Kenneth Grome

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:

A question on sub-categories (1997) bad idea to not use any html files, only .tpl files? (1999) Running 2 two WebCatalog.acgi's (1996) PhotoMill -> PhotoMaster (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) Errant Email. (1998) Questions To Answer (1997) RePost: NAT and the CART (1999) Configuring E-mail (1997) Balancing randomness (2000) syntax question, not in online refernce (1997) Help! WebCat2 bug (1997) Protect vs Authenicate (1997) File Uploads... (1997) Simple way to create unique SKU (1997) More Discount Pricing thoughts/efforts (1998) Upgrading old WebCat Database Files (1997) Using Cookie for client specific info? (1997) What is this error message? (2006) all records returned. (1997)