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 = 104103
interpreted = N
texte = Hi Chris, DB size is 96 MB and the Automatically Commit to Databases to Disk after = Modification is enabled and in works fine under normal operations but I = can see where you are getting if you need to write to 700.000 records in = one process. Actually, will it write once or 700.000 times in such a = process? Mac OS X Server 10.5.8 8 GB RAM 2x2.8 GHz Quad Core Intel Xeon Palle On 03/12/2009, at 14.07, christophe.billiottet@webdna.us wrote: > 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) ? >=20 > thank you! > - chris >=20 >=20 > On Dec 2, 2009, at 18:27, Palle Bo Nielsen wrote: >=20 >> 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 >=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 >=20
Associated Messages, from the most recent to the oldest:
Hi Chris, DB size is 96 MB and the Automatically Commit to Databases to Disk after = Modification is enabled and in works fine under normal operations but I = can see where you are getting if you need to write to 700.000 records in = one process. Actually, will it write once or 700.000 times in such a = process? Mac OS X Server 10.5.8 8 GB RAM 2x2.8 GHz Quad Core Intel Xeon Palle On 03/12/2009, at 14.07, christophe.billiottet@webdna.us wrote: > 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) ? >=20 > thank you! > - chris >=20 >=20 > On Dec 2, 2009, at 18:27, Palle Bo Nielsen wrote: >=20 >> 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 >=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 >=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:
EmailProblem vs EmailComplete (2000)
[WebDNA] Error 500 with SUMM=T (2017)
Locking up with WebCatalog... (1997)
CloseDataBase vs CommitDataBase (2007)
Re:trouble (1997)
WebCat2.0 [format thousands .0f] no go (1997)
[searchString] (1997)
sendmail (2005)
WC2b15 File Corruption (1997)
international time (1997)
[WebDNA] test (2010)
.tmp files (2000)
WebCatalog can't find database (1997)
version 2 for NT (1997)
emailer settings and control questions (1997)
[format] problem (2001)
getchars broken? (1997)
includes and cart numbers (1997)
Authenticate (1997)
Highlighting words found in a keyword search (2003)