[WebDNA] Comparisons

This WebDNA talk-list message is from

2011

It keeps the original formatting. numero = 106183
interpreted = N
texte = --Apple-Mail-14--149029506Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiHere some WebDNA 6.0, 6.2 and 7.0 as well as some php/MySQL tests. The =test files are included=--------------------------------------------------------------------------=-------php/MySQLquad Opteron 2.2GHz, 4GB RAM for apache/php Ubuntu 8quad Opteron 2.2GHz, 8GB RAM for MySQL 5 Ubuntu 8Text Variables - Set an increasing # into a text variable 10000 times..: = 0.03 sLet's do some math (10000 times).......................................: = 0.05 sOpen database (2 fields), append 10000 records.........................: = 3 sSearch 40000 Records...................................................: =105 sDelete 10000 Records...................................................: = 35 s=--------------------------------------------------------------------------=-------WebDNA CICADAiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 5 sLet's do some math: sin(x) 10000 times.................................: = 1 sOpen a database (2 fields), append 10000 records.......................: = 2 sNow 40000 searches with [lookup].......................................: = 2 s10000 searches with [search]...........................................: = 20 sDelete 10000 records...................................................: = 7 s=--------------------------------------------------------------------------=-------WebDNA 6.0a under Ubuntu 8quad Opteron 2.2GHz, 4GB RAM for apache/WebDNAText Variables - Set an increasing # into a text variable 10000 times..: = 13 sLet's do some math: sin(x) 10000 times.................................: = 10 sOpen a database (2 fields), append 10000 records.......................: = 13 sNow 40000 searches with [lookup].......................................: = 70 s10000 searches with [search]...........................................: = 27 sDelete 10000 records...................................................: = 9 s=--------------------------------------------------------------------------=-------WebDNA 7.0 under OSXiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 5 sLet's do some math: sin(x) 10000 times.................................: = <1 sOpen a database (2 fields), append 10000 records.......................: = <1 sNow 40000 searches with [lookup].......................................: = 2 s10000 searches with [search]...........................................: = 17 sDelete 10000 records...................................................: = 5 s=--------------------------------------------------------------------------=-------Here the rough code:--Apple-Mail-14--149029506Content-Disposition: attachment;filename=stress.phpContent-Type: text/php;name="stress.php"Content-Transfer-Encoding: 7bit                               

Description	This Task (seconds / ticks)	Total (seconds / ticks)
	/ "; echo round($time1*60);?>	/ "; echo round($totaltime*60);?>
	/ "; echo round($time3*60);?>	/ "; echo round($totaltime*60);?>
	/ "; echo round($time4*60);?>	/ "; echo round($totaltime*60);?>
	/ "; echo round($time5*60);?>	/ "; echo round($totaltime*60);?>
	/ "; echo round($time6*60);?>	/ "; echo round($totaltime*60);?>

--Apple-Mail-14--149029506Content-Disposition: attachment;filename=stress.dnaContent-Type: application/octet-stream;name="stress.dna"Content-Transfer-Encoding: 7bit[!] ##Check for the Database first - create it if not there--[/!][showif T=[fileinfo file=speed.db][exists][/fileinfo]][closedatabase db=speed.db][deletefile file=speed.db][/showif][showif F=[fileinfo file=speed.db][exists][/fileinfo]][writefile file=speed.db]skuvalue[/writefile][/showif][!] ##Delete the records in the DB to ensure the search is 'clean'--[/!][delete db=speed.db&neSKUdata=find_all] 

(seconds)	This Task
Variables
Text Variables - Set an increasing # into a text variable 10000 times	[Math time]{[time]}-{[start_time]}[/Math]
Let's do some math: sin(x), 0<x<51, 10000 times.	[Math time]{[time]}-{[start_time]}[/Math]
Database Manipulation
Open a database (2 fields), append 10000 records	[Math time]{[time]}-{[start_time]}[/Math]
Now 40000 searches with [raw][lookup][/raw]	[Math time]{[time]}-{[start_time]}[/Math]
10000 searches with [raw][search][/raw]	[Math time]{[time]}-{[start_time]}[/Math]
Delete the records	[Math time]{[time]}-{[start_time]}[/Math]

--Apple-Mail-14--149029506Content-Transfer-Encoding: 7bitContent-Type: text/plain;charset=us-ascii- chris--Apple-Mail-14--149029506-- Associated Messages, from the most recent to the oldest:

[WebDNA] Comparisons (christophe.billiottet@webdna.us 2011) Re: [WebDNA] Comparisons in "if" and "case" statements (christophe.billiottet@webdna.us 2010) Re: [WebDNA] Comparisons in "if" and "case" statements (Govinda 2010) [WebDNA] Comparisons in "if" and "case" statements (William DeVaul 2010)

--Apple-Mail-14--149029506Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiHere some WebDNA 6.0, 6.2 and 7.0 as well as some php/MySQL tests. The =test files are included=--------------------------------------------------------------------------=-------php/MySQLquad Opteron 2.2GHz, 4GB RAM for apache/php Ubuntu 8quad Opteron 2.2GHz, 8GB RAM for MySQL 5 Ubuntu 8Text Variables - Set an increasing # into a text variable 10000 times..: = 0.03 sLet's do some math (10000 times).......................................: = 0.05 sOpen database (2 fields), append 10000 records.........................: = 3 sSearch 40000 Records...................................................: =105 sDelete 10000 Records...................................................: = 35 s=--------------------------------------------------------------------------=-------WebDNA CICADAiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 5 sLet's do some math: sin(x) 10000 times.................................: = 1 sOpen a database (2 fields), append 10000 records.......................: = 2 sNow 40000 searches with [lookup].......................................: = 2 s10000 searches with [search]...........................................: = 20 sDelete 10000 records...................................................: = 7 s=--------------------------------------------------------------------------=-------WebDNA 6.0a under Ubuntu 8quad Opteron 2.2GHz, 4GB RAM for apache/WebDNAText Variables - Set an increasing # into a text variable 10000 times..: = 13 sLet's do some math: sin(x) 10000 times.................................: = 10 sOpen a database (2 fields), append 10000 records.......................: = 13 sNow 40000 searches with [lookup].......................................: = 70 s10000 searches with [search]...........................................: = 27 sDelete 10000 records...................................................: = 9 s=--------------------------------------------------------------------------=-------WebDNA 7.0 under OSXiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 5 sLet's do some math: sin(x) 10000 times.................................: = <1 sOpen a database (2 fields), append 10000 records.......................: = <1 sNow 40000 searches with [lookup].......................................: = 2 s10000 searches with [search]...........................................: = 17 sDelete 10000 records...................................................: = 5 s=--------------------------------------------------------------------------=-------Here the rough code:--Apple-Mail-14--149029506Content-Disposition: attachment;filename=stress.phpContent-Type: text/php;name="stress.php"Content-Transfer-Encoding: 7bit                               

Description	This Task (seconds / ticks)	Total (seconds / ticks)
	/ "; echo round($time1*60);?>	/ "; echo round($totaltime*60);?>
	/ "; echo round($time3*60);?>	/ "; echo round($totaltime*60);?>
	/ "; echo round($time4*60);?>	/ "; echo round($totaltime*60);?>
	/ "; echo round($time5*60);?>	/ "; echo round($totaltime*60);?>
	/ "; echo round($time6*60);?>	/ "; echo round($totaltime*60);?>

--Apple-Mail-14--149029506Content-Disposition: attachment;filename=stress.dnaContent-Type: application/octet-stream;name="stress.dna"Content-Transfer-Encoding: 7bit[!] ##Check for the Database first - create it if not there--[/!][showif T=[fileinfo file=speed.db][exists][/fileinfo]][closedatabase db=speed.db][deletefile file=speed.db][/showif][showif F=[fileinfo file=speed.db][exists][/fileinfo]][writefile file=speed.db]skuvalue[/writefile][/showif][!] ##Delete the records in the DB to ensure the search is 'clean'--[/!][delete db=speed.db&neSKUdata=find_all] 

(seconds)	This Task
Variables
Text Variables - Set an increasing # into a text variable 10000 times	[Math time]{[time]}-{[start_time]}[/Math]
Let's do some math: sin(x), 0<x<51, 10000 times.	[Math time]{[time]}-{[start_time]}[/Math]
Database Manipulation
Open a database (2 fields), append 10000 records	[Math time]{[time]}-{[start_time]}[/Math]
Now 40000 searches with [raw][lookup][/raw]	[Math time]{[time]}-{[start_time]}[/Math]
10000 searches with [raw][search][/raw]	[Math time]{[time]}-{[start_time]}[/Math]
Delete the records	[Math time]{[time]}-{[start_time]}[/Math]

--Apple-Mail-14--149029506Content-Transfer-Encoding: 7bitContent-Type: text/plain;charset=us-ascii- chris--Apple-Mail-14--149029506-- 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:

Preventing code execution (2003) WebDNA Quick Reference (Reserved Words) (2000) [OT] Airport Problem (2003) OT - quiet on the list today - here's something (2004) Preferred Web Design Tool? (1999) Emailer (1997) User can't change a password (2002) WebCat b13 CGI -shownext- (1997) Server Takes 2 Hours to Boot UP (2004) Subject: Authenticating users without dialog box (1997) WebCat2 beta 11 - new prefs ... (1997) WebCat2 beta 11 - new prefs ... (1997) Major problem (1999) Need relative path explanation (1997) Help with Repost Data msg from form (1997) File Upload, Browser Timeout (2003) Shopping carts and reloading pages (1997) shipcost (1997) autosensing lanague selection (1997) Emailer (WebCat2) (1997)