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 = 104084
interpreted = N
texte = > 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 Stronghttp://www.DanStrong.comPalle 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>
Associated Messages, from the most recent to the oldest:
> 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 Stronghttp://www.DanStrong.comPalle 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>
Dan Strong
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:
How To question on setting up downloads (1997)
Electronic Delivery (1997)
in header include files? (1998)
Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
typhoon... (1997)
more multiple items to shopping cart (2000)
Error Lob.db records error message not name (1997)
URGENT: WebDNA Server Not Running (2003)
WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997)
THANKS (1997)
New user...how do I create URLs from form fields? (2000)
Questions To Answer (1997)
StoreBuilder Shopping Cart (2000)
AccountAuthorizer doesn't seem to work (1997)
Search Engine questions ... (2002)
[OT] will work for... (2003)
Form and Context Searching -Hideif/Showif (2000)
Auto entering Friday's date in a field (2002)
2 easy questions re: [showif] and [sendmail] (1997)
[ListFiles] & [loop] (1998)