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.ChasOn 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:
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.ChasOn 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:
Re2: Calculating multiple shipping... (1997)
WebCatalog2 for NT Beta Request (1997)
Cool new site (1996)
server2003 isolation mode (2004)
Great product and great job ! (1997)
forms and variables (1998)
Cookies (1999)
RE: [sendmail]- bcc? (1998)
[UPPERCASE] (1997)
[taxRate] [TaxTotal] ? (1997)
delete a file? (1998)
[item] appears after 'remove last item' ... (1997)
ReturnRaw and redirect one last question (1997)
SSL and reg web* (1997)
passing cart value (2003)
OT: Where to turn (2003)
[WebDNA] html email.. should be a no-brainer.. but it is not parsing. (?) (2010)
It just Does't add up!!! (1997)
Multiple Pulldowns (1997)
WebCat2 beta 11 - new prefs ... (1997)