Re: [WebDNA] some tests

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107157
interpreted = N
texte = 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. Is that right? On Fri, Jul 29, 2011 at 3:41 PM, wrote: > I just ran some tests: the new [append] tag is really fast :-) > > iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Only commit databases to = disk when instructed" > > Open a database (2 fields), append 10000 records =A0 =A0 =A0 =A000:00:00 > Now 40000 searches with [lookup] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A000:00:02 > 10000 searches with [search] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A000:00:18 > Delete the records =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A000:00:05 > Open a database, append 10000 rec using [replace] =A0 =A0 =A0 00:00:06 > > > iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Automatically commit data= bases to disk after modification" > > Open a database (2 fields), append 10000 records =A0 =A0 =A0 =A000:00:03 > Now 40000 searches with [lookup] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A000:00:03 > 10000 searches with [search] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A000:00:17 > Delete the records =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A000:00:05 > Open a database, append 10000 rec using [replace] =A0 =A0 =A0 00:00:09 > > > PowerPC G5 1.8GHz 4GB RAM WebDNA 6.0a with "Automatically commit database= s to disk after modification" > > Open a database (2 fields), append 10000 records =A0 =A0 =A0 =A000:00:14 > Now 40000 searches with [lookup] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A000:00:56 > 10000 searches with [search] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A000:00:42 > Delete the records =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A000:00:21 > Open a database, append 10000 rec using [replace] =A0 =A0 =A0 00:00:22 > > > MacMini Core 2 Duo 2.26GHz 8GB RAM WebDNA 6.2 with "Automatically commit = databases to disk after modification" > > Open a database (2 fields), append 10000 records =A0 =A0 =A0 =A000:00:04 > Now 40000 searches with [lookup] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A000:00:02 > 10000 searches with [search] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A000:00:19 > Delete the records =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A000:00:06 > Open a database, append 10000 rec using [replace] =A0 =A0 =A0 00:00:08 > > > > 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)
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. Is that right? On Fri, Jul 29, 2011 at 3:41 PM, wrote: > I just ran some tests: the new [append] tag is really fast :-) > > iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Only commit databases to = disk when instructed" > > Open a database (2 fields), append 10000 records =A0 =A0 =A0 =A000:00:00 > Now 40000 searches with [lookup] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A000:00:02 > 10000 searches with [search] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A000:00:18 > Delete the records =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A000:00:05 > Open a database, append 10000 rec using [replace] =A0 =A0 =A0 00:00:06 > > > iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Automatically commit data= bases to disk after modification" > > Open a database (2 fields), append 10000 records =A0 =A0 =A0 =A000:00:03 > Now 40000 searches with [lookup] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A000:00:03 > 10000 searches with [search] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A000:00:17 > Delete the records =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A000:00:05 > Open a database, append 10000 rec using [replace] =A0 =A0 =A0 00:00:09 > > > PowerPC G5 1.8GHz 4GB RAM WebDNA 6.0a with "Automatically commit database= s to disk after modification" > > Open a database (2 fields), append 10000 records =A0 =A0 =A0 =A000:00:14 > Now 40000 searches with [lookup] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A000:00:56 > 10000 searches with [search] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A000:00:42 > Delete the records =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A000:00:21 > Open a database, append 10000 rec using [replace] =A0 =A0 =A0 00:00:22 > > > MacMini Core 2 Duo 2.26GHz 8GB RAM WebDNA 6.2 with "Automatically commit = databases to disk after modification" > > Open a database (2 fields), append 10000 records =A0 =A0 =A0 =A000:00:04 > Now 40000 searches with [lookup] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A000:00:02 > 10000 searches with [search] =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A000:00:19 > Delete the records =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A000:00:06 > Open a database, append 10000 rec using [replace] =A0 =A0 =A0 00:00:08 > > > > William DeVaul

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:

Bug Report, maybe (1997) QuitFeedback & DBNotOpened errors (1997) Duplicate emails being sent - only since last night (2002) Adding repeating events to a database (2001) Possible to reset Linux file permissions w/in webcat [shell] ? (2000) WebCat2b12 Mac.acgi--[searchstring] bug (1997) Now you see it now you donīt (1997) using showpage and showcart commands (1996) b12 cannot limit records returned and more. (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Live Webcasts (1999) OSX 10.1.1 (2001) Problems with shopping cart (1997) Subtotal Not Calculated on Invoice.html (1998) Not really WebCat (1997) Fulfillment e-mail? (1998) OT: BulkRegister.com (2002) Fedora Core 3 and WebDNA (2005) WCS Newbie question (1997) WebCat editing, SiteGuard & SiteEdit (1997)