Re: [WebDNA] some tests

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107158
interpreted = N
texte = Exact: except for the [append] tag, 6.2 module and 7.0 FastCGI should = have the same perf with the same hardware. It would be interesting to = run speed tests comparing 7.0 / apache and 7.0 / lighttpd, the second = one having smaller footprint, less chit-chat between the webserver and = the browser and a better designed FastCGI interface. - chris On Jul 30, 2011, at 0:13, William DeVaul wrote: > I'm looking at the second and fourth examples and without knowing more > it seems that the the difference between 6.2 and 7.0 is processor > speed related. >=20 > Is that right? >=20 > On Fri, Jul 29, 2011 at 3:41 PM, = wrote: >> I just ran some tests: the new [append] tag is really fast :-) >>=20 >> iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Only commit databases = to disk when instructed" >>=20 >> Open a database (2 fields), append 10000 records 00:00:00 >> Now 40000 searches with [lookup] 00:00:02 >> 10000 searches with [search] 00:00:18 >> Delete the records 00:00:05 >> Open a database, append 10000 rec using [replace] 00:00:06 >>=20 >>=20 >> iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Automatically commit = databases to disk after modification" >>=20 >> Open a database (2 fields), append 10000 records 00:00:03 >> Now 40000 searches with [lookup] 00:00:03 >> 10000 searches with [search] 00:00:17 >> Delete the records 00:00:05 >> Open a database, append 10000 rec using [replace] 00:00:09 >>=20 >>=20 >> PowerPC G5 1.8GHz 4GB RAM WebDNA 6.0a with "Automatically commit = databases to disk after modification" >>=20 >> Open a database (2 fields), append 10000 records 00:00:14 >> Now 40000 searches with [lookup] 00:00:56 >> 10000 searches with [search] 00:00:42 >> Delete the records 00:00:21 >> Open a database, append 10000 rec using [replace] 00:00:22 >>=20 >>=20 >> MacMini Core 2 Duo 2.26GHz 8GB RAM WebDNA 6.2 with "Automatically = commit databases to disk after modification" >>=20 >> Open a database (2 fields), append 10000 records 00:00:04 >> Now 40000 searches with [lookup] 00:00:02 >> 10000 searches with [search] 00:00:19 >> Delete the records 00:00:06 >> Open a database, append 10000 rec using [replace] 00:00:08 >>=20 >>=20 >>=20 >>=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 > Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] some tests (christophe.billiottet@webdna.us 2011)
  2. Re: [WebDNA] some tests (William DeVaul 2011)
  3. [WebDNA] some tests (christophe.billiottet@webdna.us 2011)
Exact: except for the [append] tag, 6.2 module and 7.0 FastCGI should = have the same perf with the same hardware. It would be interesting to = run speed tests comparing 7.0 / apache and 7.0 / lighttpd, the second = one having smaller footprint, less chit-chat between the webserver and = the browser and a better designed FastCGI interface. - chris On Jul 30, 2011, at 0:13, William DeVaul wrote: > I'm looking at the second and fourth examples and without knowing more > it seems that the the difference between 6.2 and 7.0 is processor > speed related. >=20 > Is that right? >=20 > On Fri, Jul 29, 2011 at 3:41 PM, = wrote: >> I just ran some tests: the new [append] tag is really fast :-) >>=20 >> iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Only commit databases = to disk when instructed" >>=20 >> Open a database (2 fields), append 10000 records 00:00:00 >> Now 40000 searches with [lookup] 00:00:02 >> 10000 searches with [search] 00:00:18 >> Delete the records 00:00:05 >> Open a database, append 10000 rec using [replace] 00:00:06 >>=20 >>=20 >> iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Automatically commit = databases to disk after modification" >>=20 >> Open a database (2 fields), append 10000 records 00:00:03 >> Now 40000 searches with [lookup] 00:00:03 >> 10000 searches with [search] 00:00:17 >> Delete the records 00:00:05 >> Open a database, append 10000 rec using [replace] 00:00:09 >>=20 >>=20 >> PowerPC G5 1.8GHz 4GB RAM WebDNA 6.0a with "Automatically commit = databases to disk after modification" >>=20 >> Open a database (2 fields), append 10000 records 00:00:14 >> Now 40000 searches with [lookup] 00:00:56 >> 10000 searches with [search] 00:00:42 >> Delete the records 00:00:21 >> Open a database, append 10000 rec using [replace] 00:00:22 >>=20 >>=20 >> MacMini Core 2 Duo 2.26GHz 8GB RAM WebDNA 6.2 with "Automatically = commit databases to disk after modification" >>=20 >> Open a database (2 fields), append 10000 records 00:00:04 >> Now 40000 searches with [lookup] 00:00:02 >> 10000 searches with [search] 00:00:19 >> Delete the records 00:00:06 >> Open a database, append 10000 rec using [replace] 00:00:08 >>=20 >>=20 >>=20 >>=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 > Bug Reporting: support@webdna.us 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:

Interfacing WebMerchant to www.fedex.com (1997) [Webcat 2]Next (1997) syntax question, not in online refernce (1997) [WebDNA] Recursive File Listing (Listfile) (2019) using listfiles to build a database? (2000) [WebDNA] WebDNA 8 (2014) Emailer question (2003) Re:WebCatalog vidoes (was: Prices Dropped) (1998) Re:quit command on NT (1997) Weird Cookie Problem Part 2 (2007) Trouble serving graphics on protected templates (1998) 9 digit zip (2002) [TCPConnect] questions/problems (2001) Snake Bites (1997) (2000) RE: 2nd WebCatalog2 Feature Request (1996) Quick ShowIf question (1997) ShowNext context limited to 500 hits? (2000) show if date < expiry date (2002) WebCatalog and directory indexing (1998)