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 = 104091
interpreted = N
texte = I think he's trying to chew through 700,000 records, not 7,000 if that makes any difference in your approach. -Dan Strong http://www.DanStrong.com Kenneth Grome wrote: >> but is [index] avail. in [replacefounditems]? > > I think so because it's a looping context and from what I recall [index] is available in all looping contexts (or at least the ones I use anyways). > > My code was wrong anyways, it would only write values of 1-100, it should have been this instead: > > [math show=f]count=0[/math] > > [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=[math]count=count+1[/math][/replacefounditems] > [/search] > [/waitforfile] > [/loop] > --------------------------------------------------------- > 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 > 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)
I think he's trying to chew through 700,000 records, not 7,000 if that makes any difference in your approach. -Dan Strong http://www.DanStrong.com Kenneth Grome wrote: >> but is [index] avail. in [replacefounditems]? > > I think so because it's a looping context and from what I recall [index] is available in all looping contexts (or at least the ones I use anyways). > > My code was wrong anyways, it would only write values of 1-100, it should have been this instead: > > [math show=f]count=0[/math] > > [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=[math]count=count+1[/math][/replacefounditems] > [/search] > [/waitforfile] > [/loop] > --------------------------------------------------------- > 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 > Dan Strong

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:

Nested vs conditional (1997) I'm Baaaaaaaaaack - Questions! (2000) Calendar (1997) Multiple serial numbers (1997) Help! WebCat2 bug (1997) Separate SSL Server (1997) [OT] What System Software? (2003) WebCat editing, SiteGuard & SiteEdit (1997) Reminder... (2003) Bug Report, maybe (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) WCS Newbie question (1997) WebSTAR plugin update (2004) Dark Horse Comics success story (1997) RE: Answer: WebDelivery downloads alias, not original ? (1997) Alternative to Authorize.net (2002) WebCatalog Beta Documentation (1997) No Access warning when caching HTML files (1997) two questions (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)