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?-GOn 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------------Govindagovinda.webdnatalk@gmail.com
Associated Messages, from the most recent to the oldest:
but is [index] avail. in [replacefounditems]?I assume we need to be inside [founditems] to get [index].no?-GOn 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------------Govindagovinda.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)