Re: [WebDNA] php/mySQL version of WebDNA Speed Test?
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102133
interpreted = N
texte = Based on what we have, i will post tomorrow a new php test and a new WebDNA test, with 10 times more search/append/delete, taking care that both tests accomplish the same tasks. chris On Mar 4, 2009, at 17:48, christophe.billiottet@webdna.us wrote: > 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/ > > --------------------------------------------------------- > 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:
Based on what we have, i will post tomorrow a new php test and a new WebDNA test, with 10 times more search/append/delete, taking care that both tests accomplish the same tasks. chris On Mar 4, 2009, at 17:48, christophe.billiottet@webdna.us wrote: > 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/ > > --------------------------------------------------------- > 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:
HTML encoding in URLs (1997)
Need relative path explanation (1997)
Mixing and/or in searches (1998)
International Orders (1998)
WC2b15 File Corruption (1997)
Email Problem (1997)
windows 95 netscape 3.01 browser bug? (1997)
Install Webcat 4.01 - Server Hard Freeze (2000)
Banner Sleuth Updater (1999)
WebCat & Oracle (2001)
[WebDNA] Upgrade pricing (2008)
Repost paging through results detail view (2003)
[WebDNA] HTML [sendmail] revisited (2009)
REPLACE problem (2000)
dates and hex formatting (1997)
3.08 installer (2003)
problems with 2 tags (1997)
Hyperboard users wanting a quoted message (1998)
Appending space (1998)
Email (1998)