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 = 104080
interpreted = N
texte = just a quick thought/test - try that again but like this: [search db=l4.db&nel4_statusdata=dummy&asl4_serialsort=1][numFound] [foundItems][ReplaceFoundItems]l4_index=[index][/ReplaceFoundItems][/ foundItems] [/search] using [founditems] to wrap [ReplaceFoundItems] is dumb, but how to get the next val for the [l4_index] field with *min.* impact on webdna.. hmmm... Anyway, I *assume* that you are still better off with my above suggestion than with the nested [replace] which has to find the record all over again.. on each and every iteration. or take it down and do it in something offline (mac? filemaker?) and then fire it up again online.. having written code to populate the new records *as you create them*, at the time you [append], [replace .. &append=T]) -G On Dec 2, 2009, at 1:27 PM, 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 ------------ Govinda govinda.webdnatalk@gmail.com 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)
just a quick thought/test - try that again but like this: [search db=l4.db&nel4_statusdata=dummy&asl4_serialsort=1][numFound] [founditems][replacefounditems]l4_index=[index][/ReplaceFoundItems][/ foundItems] [/search] using [founditems] to wrap [replacefounditems] is dumb, but how to get the next val for the [l4_index] field with *min.* impact on webdna.. hmmm... Anyway, I *assume* that you are still better off with my above suggestion than with the nested [replace] which has to find the record all over again.. on each and every iteration. or take it down and do it in something offline (mac? filemaker?) and then fire it up again online.. having written code to populate the new records *as you create them*, at the time you [append], [replace .. &append=T]) -G On Dec 2, 2009, at 1:27 PM, 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 ------------ Govinda govinda.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:

Re2: AAgghh!! Help, please. SSL strikes again. (1997) Searching for Nothing (1998) I've been thinking (2002) Email notification to one of multiple vendors ? (1997) input and accents (2000) Unique SKU Numbers (2000) Installation webCatalog (French speakers please help) (1998) creator code (1997) Case statement (2003) database size? (1997) can WC render sites out? (1997) WebCatalog [FoundItems] Problem - AGAIN - (1997) writing db to disk (1997) Search returns all, not 20 (1997) WebStar CGI Version (2005) Mac System Experience (1998) [isfile] ? (1997) [subtotal] problems -- help? (1998) Counting files (1998) Lookups (2000)