Re: [WebDNA] Append speed limits
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101423
interpreted = N
texte = There are tricks you can use to speed up the appends. For one, you could close the DB and use APPENDFILE instead. You can even gather multiple records to be appended in a text variable, then APPENDFILE in bulk to add multiple records in one shot. The next time you open the DB, the newly written records will be searchable, as long as you are careful to fomat the data records exactly as WebDNA would have via an APPEND. I use this type of a technique when writing out log files, as they don't need to be searchable while they're being written to. Brian Fries BrainScan Software On Nov 13, 2008, at 9:23 PM, Kenneth Grome wrote: > I need about 20,000 appends per second to use WebDNA in a > particular system. I don't think its performance is quite > that fast but I can still hope for this speed until I try > it I guess. > > Thanks ... :) > > Sincerely, > Ken Grome > > > > > > >> Pretty easy to work that one out Ken >> >> Make sure that preferences do not have auto save after >> append. >> >> 10,000 appends in a template with time at start and time >> at end. >> >> The speed will depend on the computer running WebDNA plus >> the amount of data that will be in each append and how >> easy it is to append ie straight data or calculated data. >> >> >> Regards >> >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >> >> On 13/11/2008, at 11:17 PM, Kenneth Grome wrote: >>> Who can tell me how many appends WebDNA can process per >>> second without committing each change to disk? Anyone? >>> >>> Has anyone ever done this type of testing? >>> >>> Sincerely, >>> Ken Grome >>> ------------------------------------------------------- >>> -- 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/ >> >> --------------------------------------------------------- >> 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/ > > > --------------------------------------------------------- > 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/
Associated Messages, from the most recent to the oldest:
There are tricks you can use to speed up the appends. For one, you could close the DB and use APPENDFILE instead. You can even gather multiple records to be appended in a text variable, then APPENDFILE in bulk to add multiple records in one shot. The next time you open the DB, the newly written records will be searchable, as long as you are careful to fomat the data records exactly as WebDNA would have via an APPEND. I use this type of a technique when writing out log files, as they don't need to be searchable while they're being written to. Brian Fries BrainScan Software On Nov 13, 2008, at 9:23 PM, Kenneth Grome wrote: > I need about 20,000 appends per second to use WebDNA in a > particular system. I don't think its performance is quite > that fast but I can still hope for this speed until I try > it I guess. > > Thanks ... :) > > Sincerely, > Ken Grome > > > > > > >> Pretty easy to work that one out Ken >> >> Make sure that preferences do not have auto save after >> append. >> >> 10,000 appends in a template with time at start and time >> at end. >> >> The speed will depend on the computer running WebDNA plus >> the amount of data that will be in each append and how >> easy it is to append ie straight data or calculated data. >> >> >> Regards >> >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >> >> On 13/11/2008, at 11:17 PM, Kenneth Grome wrote: >>> Who can tell me how many appends WebDNA can process per >>> second without committing each change to disk? Anyone? >>> >>> Has anyone ever done this type of testing? >>> >>> Sincerely, >>> Ken Grome >>> ------------------------------------------------------- >>> -- 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/ >> >> --------------------------------------------------------- >> 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/ > > > --------------------------------------------------------- > 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/
Brian Fries
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:
webcatalog 2.1.3 ACGI Weirdness? (1998)
Re(6): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
webcatalog and webmerchant 2.1 (1998)
Re:2nd WebCatalog2 Feature Request (1996)
Bug Report, maybe (1997)
Bug Report, maybe (1997)
SEA files (1996)
WebCat2b15MacPlugin - showing [math] (1997)
MacFinder -- a new WebDNA web site (1998)
RE: IIS4b2 and WebCatalog b19 (1997)
cybercash on OSX - was Executing remote AppleScript (2000)
emailer on Windows Beta 18 (1997)
P2: How to make webcatalog more stable. - LONG (1999)
send mail problem? (1997)
Uniqueness of Cart number (2000)
Cookie set browser session. (1998)
PIXO Support (1997)
WebCatalog for Postcards ? (1997)
Stumpted Again (1997)
Sense/Disallow HTML tags during $Append (1997)