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 = 104085
interpreted = N
texte = 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. >=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][/repla= ce] >>>> [/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
Associated Messages, from the most recent to the oldest:
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. >=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][/repla= ce] >>>> [/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
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:
Text limits in NT version? (1997)
WebCatalog NT (1996)
shipcost (1997)
WebCat Hosting - Pricing Question (2002)
Sendmail problem on UNIX (2000)
Sorting Numbers (1997)
Resetting a Formvariable (2000)
Grouping search fields, etc. (1997)
Reminder... (2003)
Keep away (1997)
WebCat2b15MacPlugin - showing [math] (1997)
NY taxRates.db? (1997)
Move WebDNA DB to MySQL (2005)
Help name our technology! (1997)
[WebDNA] TCPConnect w/ user:pass (2009)
Appending Information from one db to another (1998)
About Cookies... (2004)
Searching Records by Company (2000)
Templetes? (1999)
StoreBuilder Q's (2003)