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 = 104097
interpreted = N
texte = Hi Palle, I agree with Govinda. You could easily import the db into filemaker - (populate the index on the way into filemaker) and send it back into a db form. If you sen me a db.hdr I'd be glad to set it up. Chas On Dec 2, 2009, at 4:15 PM, Palle Bo Nielsen wrote: > Dan, > > I understand where you are getting but it would be preferable to > have the IDs immediately. > > I will let my questions live for 24 hours or so and then move to > plan B (in chunks) unless the better idea pops up from the list or > my own pillow tonight. > > Palle > > > > On 02/12/2009, at 22.06, Dan Strong wrote: > >>> 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 >> --------------------------------------------------------- >> 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)
Hi Palle, I agree with Govinda. You could easily import the db into filemaker - (populate the index on the way into filemaker) and send it back into a db form. If you sen me a db.hdr I'd be glad to set it up. Chas On Dec 2, 2009, at 4:15 PM, Palle Bo Nielsen wrote: > Dan, > > I understand where you are getting but it would be preferable to > have the IDs immediately. > > I will let my questions live for 24 hours or so and then move to > plan B (in chunks) unless the better idea pops up from the list or > my own pillow tonight. > > Palle > > > > On 02/12/2009, at 22.06, Dan Strong wrote: > >>> 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 >> --------------------------------------------------------- >> 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 chas conquest

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:

Almost a there but..bye bye NetCloak (1997) [format] (1998) weight based shipping cost questions (1997) SiteBuilder? - SlideShow (2004) [WebDNA] Date weirdness (2014) Suddenly can't see files... (2000) Running _every_ page through WebCat ? (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WC TableGrinder (1997) Word Breaks (1998) A few questions. . . (1997) Another bug to squash (WebCat2b13 Mac .acgi) (1997) Help! Odd, irreproducible happenings. (1998) WCS Newbie question (1997) Replace command help (1998) WCf2 and nested tags (1997) item sorting (1997) FW: checkboxes (2000) Error Lob.db records error message not name (1997) acrobat -> wc (1998)