RE: [PHP] Independant ASP & MSSQL Vs PHP MySQL Tests

Andy, We are releasing an open source (GPL) tool called GTKBench, that will allow live 'horse-racing' of any combo of databases and drivers, simulating TPC-A and TPC-C tests. This allows folks to compare real results in their environment, instead of relying on published benchmarks and speed claims of database and driver vendors, and to do so withougt spending the millions required to replicated the envrionments used by the big vendors for the published tests. I think it much more valuable to see comparisons on the hardware you will actually be using. Plus, GTKBench's source is open so you can peek at it to satisfy yourself that it's honest, and to extend it for use in any way necessary (e.g. add TPC-H for instance, before we get to it :). The GTKBench tool also allows multithreading tests (for scalability testing) and provides for tests with different SQL approaches, e.g the differences between exec/direct, prepare/execute, and stored procedures (perhaps web application developers will actually start to use efficient SQL instead of costly exec/directs all the time). I've run this tool with all of our competitors drivers, and many databases. So far Virtuoso outperforms any other db by a factor of 120% to 2000% , depending on database, which test, etc. I've not peformed the type of test you are planning, which I assume is to run a set of PHP pages against different databases and measure results, but I would expect no less of a 'win' on Virtuoso's part. Granted, Virtuoso isn't 'free software' and it's not GPL, so it has a strike against it in this community, but it's got more functionality than MySQL or Postgres, (e.g. virtual database, live sql-to-xml transformation, webserver, mailserver, SOAP server, WebDav server, XSLT engine, etc.) and runs on at least as many platforms. It is significantly cheaper than most of the 'commercial' databases, and starts off free with a 3-connection license. I encourage people to try it out, and I pledge Openlink's and my own dedication to ensuring satisfaction on with both performance and functionality. In short, you are right. A lot of people would like to disagree with me. I encourage them to try, not with theoretical statements but in practical comparisons. Rest assured that we are extending huge efforts to be the fastest, most robust, and most functional database and integration server on the planet. Respectfully, Andrew ---------------------------------------------------- Andrew Hill Professional Services Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers -----Original Message----- From: Andy Woolley [mailto:andy@milonic.com] Sent: Wednesday, August 02, 2000 9:21 AM To: ahill@openlinksw.com Cc: php-general@lists.php.net; mysql@lists.mysql.com Subject: Re: [PHP] Independant ASP & MSSQL Vs PHP MySQL Tests Andrew, That's a bold statement you made there, and I'm sure that a lot of people would like to disagree with you. I recently saw a statement made by a MySQL developer stating that MySQL is one of the fastest SQL Databases in the world. If you do know of a faster one then I'm sure that we would all love to see what it can do. I am attempting to prove many differences between certain web applications running on either Unix based platforms or Windows NT based platforms. Comparing cost of ownership, reliability and performance. The tests will involve standard software installations running on exactly the same hardware. I will be testing low specification machines as well as high performance machines. Initially I will be comparing MS-SQL & ASP against MySQL & PHP. I intend to test Postgres SQL and will of course test the software contained in www.openlinksw.com/virtuoso as soon as I can connect to their web site. Regards Andy Woolley. ----- Original Message ----- From: "Andrew Hill" <ahill@openlinksw.com> To: "Andy Woolley" <andy@milonic.com>; <rasmus@php.net> Cc: <php-general@lists.php.net> Sent: Wednesday, August 02, 2000 1:54 PM Subject: RE: [PHP] Independant ASP & MSSQL Vs PHP MySQL Tests > Andy, > > How are you testing? > > I'd be interested in replicating the tests here with PHP and Virtuoso > (www.openlinksw.com/virtuoso). Virtuoso is a substantially faster database > than anything out there - I'd like to see just how much faster with the same > setup. > Are you using specific database functions, e.g. mysql_connect etc., or odbc? > > Best regards, > Andrew > ---------------------------------------------------- > Andrew Hill > Professional Services Consultant > OpenLink Software > http://www.openlinksw.com > Universal Database Connectivity Technology Providers > > > -----Original Message----- > From: Andy Woolley [mailto:andy@milonic.com] > Sent: Wednesday, August 02, 2000 5:50 AM > To: rasmus@php.net > Cc: php-general@lists.php.net > Subject: Re: [PHP] Independant ASP & MSSQL Vs PHP MySQL Tests > > > Rasmus, > > Of course, forgot about that. Linux will be included in the tests as well. > > What are your views on donor machine. I was thinking Pentium 200 with 64 MB > Ram. Is this being a little unfair to Microsoft though. > > I could use a PIII 600 with 256MB Ram or an Athalon 650 with 256MB Ram as > well as the slower machine but it will take me longer to achieve the results > doing twice the work now. > > Andy. > > > ----- Original Message ----- > From: <rasmus@php.net> > To: "Andy Woolley" <andy@reftech.co.uk> > Cc: <php-general@lists.php.net> > Sent: Wednesday, August 02, 2000 1:43 PM > Subject: Re: [PHP] Independant ASP & MSSQL Vs PHP MySQL Tests > > > > > Over the next week or so I am going to run some performance tests on the > following: > > > > > > Microsoft 2000 Server running IIS 5, ASP and SQL Server > > > Microsoft 2000 Server running IIS 5, PHP4 and SQL Server > > > Microsoft 2000 Server running IIS 5, PHP4 and MySQL > > > > > > I am then going to Compare the results from the above with FreeBSD, PHP4 > and MySQL. > > > > You should toss a tuned Linux 2.4/MySQL 3.23/PHP 4 box in there as > > well. I am seeing some pretty nice numbers coming from that platform now. > > > > -Rasmus > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > >