wrote:> I thought that depended on the version of webcat you were running???> > The lastest update changed that didn't it?Hey I dug out the old perf test someone wrote I don't know how well itapplies but here it is anyway.Webdna Performance Test[showif F=[fileinfo file=firstdb.db][exits][/fileinfo]][writefile file=firstdb.db]sku    value[/writefile][/showif]WebDNA Performance Test 
by Matthias Precht precht@medien-gmbh.de
I will take no responsibility for anything that happens executing this code.It works on my servers.Running Time: [math]lasttime=[elapsedtime][/math]ticks
Let's do some math: sin(x), 0<x<51, 2500 times.
[loop start=1&end=50][loop start=1&end=50][mathshow=f]dummy=sin([index])[/math][/loop][/loop]
needed:[math]mneeded=[elapsedtime]-lasttime[/math]ticks
Running Time: [math]lasttime=[elapsedtime][/math]ticks
Open a database (2 fields), append 500 records
[loop start=1&end=500][appenddb=firstdb.db]sku=[index]&value=ftzn[index]ftzn[/append][/loop]
needed:[math]aneeded=[elapsedtime]-lasttime[/math] ticks
Running Time: [math]lasttime=[elapsedtime][/math]ticks
some searching stuff with [raw][search][/raw]
needed:[math]sneeded=[elapsedtime]-lasttime[/math]ticks
Running Time: [math]lasttime=[elapsedtime][/math]ticks
now some searches with [raw][lookup][/raw]
needed:[math]lneeded=[elapsedtime]-lasttime[/math]ticks
Running Time: [math]lasttime=[elapsedtime][/math]ticks
delete the records and commit database to disk
[loop start=1&end=500][delete db=firstdb.db&eqskudata=[index]][/loop][commitdatabase db=firstdb.db]
needed:[math]dneeded=[elapsedtime]-lasttime[/math]ticks
Running Time: [math]lasttime=[elapsedtime][/math]ticks
And now to something completely different: The filesystem.
Writing 500 lines of text, each 100 bytes.
[loop start=1&end=500][appendfile file=dummyfile.txt&secure=t]123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789[/appendfile][/loop]
needed:[math]wneeded=[elapsedtime]-lasttime[/math]ticks
Running Time: [math]lasttime=[elapsedtime][/math]ticks
Now include this file in this page (as a HTML-comment ;-) ) two times anddelete it[deletefile file=dummyfile.txt]
needed:[math]ineeded=[elapsedtime]-lasttime[/math]ticks
Running Time: [math]lasttime=[elapsedtime][/math]ticks
If anyone has more ideas of tests to put into it, feel freeto send them to webcatlist@medien-gmbh.de.
needed:[math]xxxnedded=[elapsedtime]-lasttime[/math]ticks
Summary:
    | Time for math: | [math][mneeded][/math] ticks | for append: | [math][aneeded][/math] ticks | for search: | [math][sneeded][/math] ticks | 
    | for lookup: | [math][lneeded][/math] ticks | for appendfile: | [math][wneeded][/math] ticks | for include: | [math][ineeded][/math] ticks | 
Please send your results to dnaresults@medien-gmbh.de, together with a description of yourhardware and software setup. I will set up a comparison then. The resultswill remain anonymous, of course.
We test by using loading tools, that test volume not just initial speed.Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com        http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us!-------------------------------------------------------------This message is sent to you because you are subscribed to  the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On 7/23/02 8:19 PM, Andrew Simpson wrote:> I thought that depended on the version of webcat you were running???> > The lastest update changed that didn't it?Hey I dug out the old perf test someone wrote I don't know how well itapplies but here it is anyway.Webdna Performance Test[showif F=[fileinfo file=firstdb.db][exits][/fileinfo]][writefile file=firstdb.db]sku    value[/writefile][/showif]WebDNA Performance Test 
by Matthias Precht precht@medien-gmbh.de
I will take no responsibility for anything that happens executing this code.It works on my servers.Running Time: [math]lasttime=[elapsedtime][/math]ticks
Let's do some math: sin(x), 0<x<51, 2500 times.
[loop start=1&end=50][loop start=1&end=50][mathshow=f]dummy=sin([index])[/math][/loop][/loop]
needed:[math]mneeded=[elapsedtime]-lasttime[/math]ticks[math]lasttime=[elapsedtime][/math]>
Running Time: [math]lasttime=[elapsedtime][/math]ticks
Open a database (2 fields), append 500 records
[loop start=1&end=500][appenddb=firstdb.db]sku=[index]&value=ftzn[index]ftzn[/append][/loop]
needed:[math]aneeded=[elapsedtime]-lasttime[/math] ticks[math]lasttime=[elapsedtime][/math]>
Running Time: [math]lasttime=[elapsedtime][/math]ticks
some searching stuff with [raw][search][/raw]
needed:[math]sneeded=[elapsedtime]-lasttime[/math]ticks[math]lasttime=[elapsedtime][/math]>
Running Time: [math]lasttime=[elapsedtime][/math]ticks
now some searches with [raw][lookup][/raw]
needed:[math]lneeded=[elapsedtime]-lasttime[/math]ticks[math]lasttime=[elapsedtime][/math]>
Running Time: [math]lasttime=[elapsedtime][/math]ticks
delete the records and commit database to disk
[loop start=1&end=500][delete db=firstdb.db&eqskudata=[index]][/loop][commitdatabase db=firstdb.db]
needed:[math]dneeded=[elapsedtime]-lasttime[/math]ticks[math]lasttime=[elapsedtime][/math]>
Running Time: [math]lasttime=[elapsedtime][/math]ticks
And now to something completely different: The filesystem.
Writing 500 lines of text, each 100 bytes.
[loop start=1&end=500][appendfile file=dummyfile.txt&secure=t]123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789[/appendfile][/loop]
needed:[math]wneeded=[elapsedtime]-lasttime[/math]ticks[math]lasttime=[elapsedtime][/math]>
Running Time: [math]lasttime=[elapsedtime][/math]ticks
Now include this file in this page (as a HTML-comment ;-) ) two times anddelete it[deletefile file=dummyfile.txt]
needed:[math]ineeded=[elapsedtime]-lasttime[/math]ticks[math]lasttime=[elapsedtime][/math]>
Running Time: [math]lasttime=[elapsedtime][/math]ticks
If anyone has more ideas of tests to put into it, feel freeto send them to webcatlist@medien-gmbh.de.
needed:[math]xxxnedded=[elapsedtime]-lasttime[/math]ticks[math]lasttime=[elapsedtime][/math]>
Summary:
    | Time for math: | [math][mneeded][/math] ticks | for append: | [math][aneeded][/math] ticks | for search: | [math][sneeded][/math] ticks | 
    | for lookup: | [math][lneeded][/math] ticks | for appendfile: | [math][wneeded][/math] ticks | for include: | [math][ineeded][/math] ticks | 
Please send your results to dnaresults@medien-gmbh.de, together with a description of yourhardware and software setup. I will set up a comparison then. The resultswill remain anonymous, of course.
We test by using loading tools, that test volume not just initial speed.Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com        http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us!-------------------------------------------------------------This message is sent to you because you are subscribed to  the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Bob Minor 
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:
 
[WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (2012)
 
Include a big block of text (1997)
 
Multi-processor Mac info ... (1997)
 
WebCatb15 Mac CGI -- [purchase] (1997)
 
F3 crashing server (1997)
 
 hmmm (2006)
 
WebDNA 4.5 not starting on boot? (2002)
 
Before I Can Begin . . . (1998)
 
Satisfy Me !   was: Why can't support be satisfying to (2000)
 
Setting variables. (1998)
 
something simple? (1998)
 
Shipping.db (1998)
 
 Sending Email (2004)
 
form data submission gets truncated (1997)
 
New Plug-in and Type 11 errors (1997)
 
[WebDNA] slideshow (2008)
 
Dummy Credit Card Number for debug? (1997)
 
RE: WebCat: Access denied, but why? - The solution. (1997)
 
Tab Charactor (1997)
 
A question on sub-categories (1997)