What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

    
  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)
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:

WCS Newbie question (1997) Make sure I understand this??? (1997) emailer (1997) [if] (2003) Not Enough Memory for Database? (2003) Pithy questions on webcommerce & siteedit (1997) [OT] Linux Mailservers (2003) Multiple Pulldowns (1997) Location of Browser Info.txt file (1997) LAST CHANCE! Anyone have a one-to-one messaging system? (1999) Ampersand (1997) [ShowNext] feature in 2.0 (1997) Interactive Online Docs Was: [OT] Mozilla | Was: R.I.P. (2003) Re2: Calculating multiple shipping... (1997) [shell] error? (2005) multiGroupChecker code redundant? (2000) Accepting credit cards (1997) Exchange rates (2000) Search returns all, not 20 (1997) WC1.6 to WC2 date formatting (1997)