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:

[searchString] (1997) Storing dates (was: Ticket Ordering Question) (2003) WebCat2final1 crashes (1997) RE: WebDNA-Talk searchable? (1997) Credit Card processing (1998) LOOP and IF statements (1997) [OT] DNS Problems (2004) Not really WebCat (1997) Running 2 two WebCatalog.acgi's (1996) No comment (1997) ErrorMessages.db suggestion (1997) [lineitems] (2000) Re:2nd WebCatalog2 Feature Request (1996) Summary layout (1997) RE: protect tag not working (1998) Grepping text variable tags (was: No subject given) (2000) what servers are supported for Typhoon? (1997) Database Updates (1997) webcat restarting script on Linux? (1999) FIXED: Showing Results Alphabetically in Columns (top to (2002)