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 = 104082
interpreted = N
texte = Dan,1) Yes, but is not sequential.2) Yes, same result - on it's knees.3) This is my next plan, but it would be nice to get it done in one =process.PalleOn 02/12/2009, at 21.56, Dan Strong wrote:> 1) Is there any other unique identifier in each record?> 2) Have you tried [replacefounditems]?> 3) Maybe "chunk it" to only do, say, 500 at a time?>=20> -Dan Strong> http://www.DanStrong.com>=20> Palle Bo Nielsen wrote:>> Hi all,>> I got a DB which has 11 fields and more that 700.000 lines of data.>> Now I need to add a new field and I need to populate this field with =an index from the number 1 to the most recent number which for example =is 700.000.>> The number 1 is the first lines of data within this BD and the =700.000 is the most recent added line of data.>> If have done some test and sand-boxing and every time WebDNA goes =into it's knees.>> I need some good advise from you all to figure out the best solution.>> I look forward to your suggestions.>> **** this one is rough and breaks WebDNA ****>> [search =db=3Dl4.db&nel4_statusdata=3Ddummy&asl4_serialsort=3D1][numFound][foundIte=ms]>> [replace db=3Dl4.db&eql4_skudata=3D[l4_sku]]l4_index=3D[index][/replace=]>> [/foundItems][/search]>> **** snip ****>> Palle--------------------------------------------------------->> 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=3Dtopics&category=3D288> ---------------------------------------------------------> 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=3Dtopics&category=3D288>=20
Associated Messages, from the most recent to the oldest:
Dan,1) Yes, but is not sequential.2) Yes, same result - on it's knees.3) This is my next plan, but it would be nice to get it done in one =process.PalleOn 02/12/2009, at 21.56, Dan Strong wrote:> 1) Is there any other unique identifier in each record?> 2) Have you tried [replacefounditems]?> 3) Maybe "chunk it" to only do, say, 500 at a time?>=20> -Dan Strong> http://www.DanStrong.com>=20> Palle Bo Nielsen wrote:>> Hi all,>> I got a DB which has 11 fields and more that 700.000 lines of data.>> Now I need to add a new field and I need to populate this field with =an index from the number 1 to the most recent number which for example =is 700.000.>> The number 1 is the first lines of data within this BD and the =700.000 is the most recent added line of data.>> If have done some test and sand-boxing and every time WebDNA goes =into it's knees.>> I need some good advise from you all to figure out the best solution.>> I look forward to your suggestions.>> **** this one is rough and breaks WebDNA ****>> [search =db=3Dl4.db&nel4_statusdata=3Ddummy&asl4_serialsort=3D1][numFound][foundIte=ms]>> [replace db=3Dl4.db&eql4_skudata=3D[l4_sku]]l4_index=3D[index][/replace=]>> [/foundItems][/search]>> **** snip ****>> Palle--------------------------------------------------------->> 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=3Dtopics&category=3D288> ---------------------------------------------------------> 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=3Dtopics&category=3D288>=20
Palle Bo Nielsen
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:
[addlineitems] display (1997)
WebDNA Solutions ... sorry! (1997)
[WebDNA] divisible by 1 (2011)
Calculating multiple shipping... (1997)
Emailer Error 550 (Was Strange Crash) (1998)
migrating from MacOS to unix (2000)
RE: LookUp Tag (1997)
Strange intermittent WebDNA problems (2008)
[WebDNA] Anyone using CODA ?? (2012)
b12 cannot limit records returned and more. (1997)
OT : Best book for OSX (2002)
off-topic - printinglib 68K (1997)
Re:quit command on NT (1997)
Re:Emailer and encryption (1997)
To Use Cookies or Not To Use Cookies (2003)
[SMSI]Price and Formula.db (2002)
TCPConnect/Send problem (2001)
Separate SSL Server (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Location of Browser Info.txt file (1997)