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 = 104104
interpreted = N
texte = Hi Chas, Thanks for the proposal. I have used this method before with success but = I feel that WebDNA should be able to do the trick so this is what I will = pursue. Palle On 03/12/2009, at 15.23, chas conquest wrote: > Hi Palle, >=20 > 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. >=20 > If you sen me a db.hdr I'd be glad to set it up. >=20 > Chas >=20 >=20 > On Dec 2, 2009, at 4:15 PM, Palle Bo Nielsen wrote: >=20 >> Dan, >>=20 >> I understand where you are getting but it would be preferable to have = the IDs immediately. >>=20 >> 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. >>=20 >> Palle >>=20 >>=20 >>=20 >> On 02/12/2009, at 22.06, Dan Strong wrote: >>=20 >>>> 1) Yes, but is not sequential. >>>=20 >>> 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? >>>=20 >>> -Dan Strong >>> http://www.DanStrong.com >>>=20 >>> 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? >>>>>=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 >>>> --------------------------------------------------------- >>>> 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 >>=20 >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- > 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)
Hi Chas, Thanks for the proposal. I have used this method before with success but = I feel that WebDNA should be able to do the trick so this is what I will = pursue. Palle On 03/12/2009, at 15.23, chas conquest wrote: > Hi Palle, >=20 > 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. >=20 > If you sen me a db.hdr I'd be glad to set it up. >=20 > Chas >=20 >=20 > On Dec 2, 2009, at 4:15 PM, Palle Bo Nielsen wrote: >=20 >> Dan, >>=20 >> I understand where you are getting but it would be preferable to have = the IDs immediately. >>=20 >> 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. >>=20 >> Palle >>=20 >>=20 >>=20 >> On 02/12/2009, at 22.06, Dan Strong wrote: >>=20 >>>> 1) Yes, but is not sequential. >>>=20 >>> 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? >>>=20 >>> -Dan Strong >>> http://www.DanStrong.com >>>=20 >>> 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? >>>>>=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 >>>> --------------------------------------------------------- >>>> 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 >>=20 >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- > 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:

Separate SSL Server (1997) Adding Multiple Items to Shopping Cart from a Results page (1997) Hiding Email Addresses (2003) Separate SSL Server (1997) Sample Tearoom Search Error (1997) RE: Webcatalog and CyberSTUD (1998) still having shipCost.db Problem (1997) Incorrect Store Totals (2005) Sort Order on a page search (1997) problems with 2 tags (1997) No Answer on Web Merchant Problem? (2001) Unauthorized User trouble (1998) error (2000) Migrating to NT (1997) sort problems....bug or brain fart? (1997) Re:PCS Customer submissions ? (1997) [ConvertChars] problem (1997) [append] vs. [appendfile] delta + question? (1997) WC2.0 Memory Requirements (1997) PDF on the fly - how to? (2005)