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 = 104086
interpreted = N
texte = What about[loop start=3D1&end=3D700000&advance=3D1][replace db=3Dl4.db]l4_index=3D[index][/replace][/loop]- chrisOn Dec 2, 2009, at 19:15, Palle Bo Nielsen wrote:> 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][/repl=ace]>>>>> [/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
Associated Messages, from the most recent to the oldest:
What about[loop start=3D1&end=3D700000&advance=3D1][replace db=3Dl4.db]l4_index=3D[index][/replace][/loop]- chrisOn Dec 2, 2009, at 19:15, Palle Bo Nielsen wrote:> 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][/repl=ace]>>>>> [/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
christophe.billiottet@webdna.us
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:
More than one db with the same namn (was: WC2f3) (1997)
[WriteFile] problems (1997)
emailer setup (1997)
Attn: Bug in GeneralStore example b15 (1997)
Quotation Marks in Database (1998)
Secure server question (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Protecting webdelivery (1997)
F2 to F3 rocky transition (1997)
Retirement (2000)
MasterCounter Weirdness (1997)
[TaxableTotal] - not working with AOL and IE (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Snake Bites (1997)
PCS Frames-Default page is solution! (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Mozilla/4. and Browser Info.txt (1997)
OT : Best book for OSX (2002)
Internet Explorer and caching (2000)
Help name our technology! (1997)