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 = 104096
interpreted = N
texte = Palle, just curiosity: what size (MB) is your 700,000 records database? = is the "Automatically commit databases to disk after modification" = checked in your preferences? what version of WebDNA are you running and = what is the hardware (CPU/RAM) ? thank you! - chris On Dec 2, 2009, at 18:27, Palle Bo Nielsen wrote: > Hi all, >=20 > I got a DB which has 11 fields and more that 700.000 lines of data. >=20 > 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. >=20 > The number 1 is the first lines of data within this BD and the 700.000 = is the most recent added line of data. >=20 > If have done some test and sand-boxing and every time WebDNA goes into = it's knees. >=20 > I need some good advise from you all to figure out the best solution. >=20 > I look forward to your suggestions. >=20 > **** 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][/replace]= > [/foundItems][/search] > **** snip **** >=20 >=20 > 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
Associated Messages, from the most recent to the oldest:
Palle, just curiosity: what size (MB) is your 700,000 records database? = is the "Automatically commit databases to disk after modification" = checked in your preferences? what version of WebDNA are you running and = what is the hardware (CPU/RAM) ? thank you! - chris On Dec 2, 2009, at 18:27, Palle Bo Nielsen wrote: > Hi all, >=20 > I got a DB which has 11 fields and more that 700.000 lines of data. >=20 > 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. >=20 > The number 1 is the first lines of data within this BD and the 700.000 = is the most recent added line of data. >=20 > If have done some test and sand-boxing and every time WebDNA goes into = it's knees. >=20 > I need some good advise from you all to figure out the best solution. >=20 > I look forward to your suggestions. >=20 > **** 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][/replace]= > [/foundItems][/search] > **** snip **** >=20 >=20 > 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
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:
WebCommerce: Folder organization ? (1997)
Separate SSL Server (1997)
Multiple cart additions (1997)
can WC render sites out? (1997)
Nested tags count question (1997)
[WebDNA] Feature requests - date format (2009)
TCPConnect / Current Temperature (2004)
no global [username] or [password] displayed ... (1997)
Multiple servers and Webcat (1998)
[ANN] GetRate 1.3 available (2000)
best way to store prefs (1998)
Preventing Merchant Settling ? (1997)
GuestBook example (1997)
shipcost (1997)
Re:2nd WebCatalog2 Feature Request (1996)
WebCat2 - Getting to the browser's username/password data (1997)
WebCatalog for guestbook ? (1997)
Code BabelFish (was: I've been thinking) (2002)
Emailer & IMail List Server (1998)
Sandbox Administation (2003)