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. Palle On 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:

    
  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)
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. Palle On 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)