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:
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)