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 Stronghttp://www.DanStrong.comKenneth 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:
I think he's trying to chew through 700,000 records, not 7,000 if that makes any difference in your approach.-Dan Stronghttp://www.DanStrong.comKenneth 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)