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 moreit seems that the the difference between 6.2 and 7.0 is processorspeed 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:
I'm looking at the second and fourth examples and without knowing moreit seems that the the difference between 6.2 and 7.0 is processorspeed 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)