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 = 104084
interpreted = N
texte = > 1) Yes, but is not sequential. Ok, next question: do the new, unique sequential IDs need to be in there immediately? If not, perhaps add the new uniques as the .db is otherwise being hit? -Dan Strong http://www.DanStrong.com Palle Bo Nielsen wrote: > 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? >> >> -Dan Strong >> http://www.DanStrong.com >> >> 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=l4.db&nel4_statusdata=dummy&asl4_serialsort=1][numFound][foundItems] >>> [replace db=l4.db&eql4_skudata=[l4_sku]]l4_index=[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=topics&category=288 >> --------------------------------------------------------- >> 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 >> > > --------------------------------------------------------- > 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)
> 1) Yes, but is not sequential. Ok, next question: do the new, unique sequential IDs need to be in there immediately? If not, perhaps add the new uniques as the .db is otherwise being hit? -Dan Strong http://www.DanStrong.com Palle Bo Nielsen wrote: > 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? >> >> -Dan Strong >> http://www.DanStrong.com >> >> 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=l4.db&nel4_statusdata=dummy&asl4_serialsort=1][numFound][founditems] >>> [replace db=l4.db&eql4_skudata=[l4_sku]]l4_index=[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=topics&category=288 >> --------------------------------------------------------- >> 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 >> > > --------------------------------------------------------- > 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:

How To question on setting up downloads (1997) Electronic Delivery (1997) in header include files? (1998) Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997) typhoon... (1997) more multiple items to shopping cart (2000) Error Lob.db records error message not name (1997) URGENT: WebDNA Server Not Running (2003) WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997) THANKS (1997) New user...how do I create URLs from form fields? (2000) Questions To Answer (1997) StoreBuilder Shopping Cart (2000) AccountAuthorizer doesn't seem to work (1997) Search Engine questions ... (2002) [OT] will work for... (2003) Form and Context Searching -Hideif/Showif (2000) Auto entering Friday's date in a field (2002) 2 easy questions re: [showif] and [sendmail] (1997) [ListFiles] & [loop] (1998)