Re: [WebDNA] php/mySQL version of WebDNA Speed Test?
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102128
interpreted = N
texte = In the current http://www.euca.us/webdnatest/show_speed.html test, it first wait 2 seconds, something that the php test does not do, it commits database to disk, something that obviously php does not do, it does 2 searchs with [search] and [lookup], when the php test only does a single one etc... and in spite of this, WebDNA is about twice as fast as the php test. I guess a "real world" test would be to append more DB records, then do more search and finally delete. I do not think that adding and deleting 500 folders is really representative of either WebDNA or PHP performances. In my opinion, a "real" test should show a large superiority of WebDNA over php/mysql and would be welcomed for webdna.us site! :-) chris On Mar 4, 2009, at 16:46, Dan Strong wrote: > Interesting. So do you think the results are displayed incorrectly > on the php/mySQL test (i.e. a decimal is moved over a few places, > etc.)? > -Dan > > > On Wed, 4 Mar 2009 16:41:26 -0200 > christophe.billiottet@webdna.us wrote: >> with a chronometer in hand, i get the WebDNA test complete twice >> as fast as the php/mysql one (4s30 for the WebDNA and 9s for the >> php one). >> chris >> On Mar 4, 2009, at 16:25, Dan Strong wrote: >>> Please explain. I am looking for anything to refute this test or >>> make it more accurate, since I just went up against my IT dept, as >>> a WebDNA advocate, and am not ready to concede defeat just yet. - >>> Dan >>> >>> >>> On Wed, 4 Mar 2009 16:27:03 -0200 >>> christophe.billiottet@webdna.us wrote: >>>> "Create 500 folders named 1-500 0.01627s / 1 tick".... not >>>> sure if this is reliable. >>>> On Mar 4, 2009, at 16:19, Ki Song wrote: >>>>> Is the "This Task (seconds / ticks)" column referring to PHP/mySQL >>>>> times and the "Total (seconds / ticks)" referring to WebDNA times? >>>>> >>>>> >>>>> On Wed, Mar 4, 2009 at 1:07 PM, Dan Strong >>>>>
wrote: >>>>>> I can't believe not a single person replied to this. From what >>>>>> I can see, >>>>>> unfortunately, php/mySQL beats the pants off of WebDNA in >>>>>> terms of speed, by >>>>>> nearly 10 to 1 :( -Dan >>>>>> >>>>>> >>>>>> On Tue, 03 Mar 2009 17:23:21 -0800 >>>>>> "Dan Strong" wrote: >>>>>>> >>>>>>> http://www.danstrong.com/stressTestPHP.php.zip >>>>>>> >>>>>>> I had someone code this for me. Admittedly, I am no php/ >>>>>>> mySQL expert, but >>>>>>> if the code is an actual apples-to-apples comparison, then >>>>>>> the results are >>>>>>> very interesting and not at all what I expected. >>>>>>> >>>>>>> Working example here: >>>>>>> http://www.andjelika.com/stressTest/stresstest.php >>>>>>> >>>>> >>>>> >>>>>>> -Dan >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Mon, 02 Mar 2009 16:20:07 -0800 >>>>>>> "Dan Strong" wrote: >>>>>>>> >>>>>>>> Has anyone done an apple-to-apples comparison of php/mySQL >>>>>>>> vs. WebDNA. >>>>>>>> The php/mySQL people I ask keep pointing me to 'similar' >>>>>>>> tests that "do a >>>>>>>> bunch of stuff", but I'd like to see a side-by-side >>>>>>>> comparison of php/mySQL >>>>>>>> doing exactly what the WebDNA Speed Test does (i.e. write >>>>>>>> 500 folders then >>>>>>>> delete them, etc.). Anybody? >>>>>>>> -Dan >>>>>>>> --------------------------------------------------------- >>>>>>>> This message is sent to you because you are subscribed to >>>>>>>> the mailing list . >>>>>>>> To unsubscribe, E-mail to: >>>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>>> >>>>>>> --------------------------------------------------------- >>>>>>> This message is sent to you because you are subscribed to >>>>>>> the mailing list . >>>>>>> To unsubscribe, E-mail to: >>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>> >>>>>> --------------------------------------------------------- >>>>>> This message is sent to you because you are subscribed to >>>>>> the mailing list . >>>>>> To unsubscribe, E-mail to: >>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>> >>>>> --------------------------------------------------------- >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>> old archives: http://dev.webdna.us/TalkListArchive/ >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> old archives: http://dev.webdna.us/TalkListArchive/ >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/
Associated Messages, from the most recent to the oldest:
In the current http://www.euca.us/webdnatest/show_speed.html test, it first wait 2 seconds, something that the php test does not do, it commits database to disk, something that obviously php does not do, it does 2 searchs with [search] and [lookup], when the php test only does a single one etc... and in spite of this, WebDNA is about twice as fast as the php test. I guess a "real world" test would be to append more DB records, then do more search and finally delete. I do not think that adding and deleting 500 folders is really representative of either WebDNA or PHP performances. In my opinion, a "real" test should show a large superiority of WebDNA over php/mysql and would be welcomed for webdna.us site! :-) chris On Mar 4, 2009, at 16:46, Dan Strong wrote: > Interesting. So do you think the results are displayed incorrectly > on the php/mySQL test (i.e. a decimal is moved over a few places, > etc.)? > -Dan > > > On Wed, 4 Mar 2009 16:41:26 -0200 > christophe.billiottet@webdna.us wrote: >> with a chronometer in hand, i get the WebDNA test complete twice >> as fast as the php/mysql one (4s30 for the WebDNA and 9s for the >> php one). >> chris >> On Mar 4, 2009, at 16:25, Dan Strong wrote: >>> Please explain. I am looking for anything to refute this test or >>> make it more accurate, since I just went up against my IT dept, as >>> a WebDNA advocate, and am not ready to concede defeat just yet. - >>> Dan >>> >>> >>> On Wed, 4 Mar 2009 16:27:03 -0200 >>> christophe.billiottet@webdna.us wrote: >>>> "Create 500 folders named 1-500 0.01627s / 1 tick".... not >>>> sure if this is reliable. >>>> On Mar 4, 2009, at 16:19, Ki Song wrote: >>>>> Is the "This Task (seconds / ticks)" column referring to PHP/mySQL >>>>> times and the "Total (seconds / ticks)" referring to WebDNA times? >>>>> >>>>> >>>>> On Wed, Mar 4, 2009 at 1:07 PM, Dan Strong >>>>> wrote: >>>>>> I can't believe not a single person replied to this. From what >>>>>> I can see, >>>>>> unfortunately, php/mySQL beats the pants off of WebDNA in >>>>>> terms of speed, by >>>>>> nearly 10 to 1 :( -Dan >>>>>> >>>>>> >>>>>> On Tue, 03 Mar 2009 17:23:21 -0800 >>>>>> "Dan Strong" wrote: >>>>>>> >>>>>>> http://www.danstrong.com/stressTestPHP.php.zip >>>>>>> >>>>>>> I had someone code this for me. Admittedly, I am no php/ >>>>>>> mySQL expert, but >>>>>>> if the code is an actual apples-to-apples comparison, then >>>>>>> the results are >>>>>>> very interesting and not at all what I expected. >>>>>>> >>>>>>> Working example here: >>>>>>> http://www.andjelika.com/stressTest/stresstest.php >>>>>>> >>>>> >>>>> >>>>>>> -Dan >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Mon, 02 Mar 2009 16:20:07 -0800 >>>>>>> "Dan Strong" wrote: >>>>>>>> >>>>>>>> Has anyone done an apple-to-apples comparison of php/mySQL >>>>>>>> vs. WebDNA. >>>>>>>> The php/mySQL people I ask keep pointing me to 'similar' >>>>>>>> tests that "do a >>>>>>>> bunch of stuff", but I'd like to see a side-by-side >>>>>>>> comparison of php/mySQL >>>>>>>> doing exactly what the WebDNA Speed Test does (i.e. write >>>>>>>> 500 folders then >>>>>>>> delete them, etc.). Anybody? >>>>>>>> -Dan >>>>>>>> --------------------------------------------------------- >>>>>>>> This message is sent to you because you are subscribed to >>>>>>>> the mailing list . >>>>>>>> To unsubscribe, E-mail to: >>>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>>> >>>>>>> --------------------------------------------------------- >>>>>>> This message is sent to you because you are subscribed to >>>>>>> the mailing list . >>>>>>> To unsubscribe, E-mail to: >>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>> >>>>>> --------------------------------------------------------- >>>>>> This message is sent to you because you are subscribed to >>>>>> the mailing list . >>>>>> To unsubscribe, E-mail to: >>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>> >>>>> --------------------------------------------------------- >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>> old archives: http://dev.webdna.us/TalkListArchive/ >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> old archives: http://dev.webdna.us/TalkListArchive/ >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/
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:
Text Variabels Not Passed To Include (2002)
page redirect in webDNA (1997)
webcat NT (1998)
Search design (1997)
WC TableGrinder (1997)
textarea data entry and display (2000)
Date search bug (1997)
Tab Charactor (1997)
BBEdit and WebCatalog 2.0? (1997)
Design Help Needed (1998)
Searchable list archive (1997)
WebCat2b12 - nesting [tags] (1997)
WebDNA Promo Sound Bite (2003)
The IBC root beer has arrived! (1997)
Webcat causing crashes left and right! (1997)
Session Number (1998)
BreadCrumb Trails (2001)
Calculating Shipping charges for multiple items andqtys > 1 (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
[WebDNA] path traversal (2020)