[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql-java
Subject: Articles that support MySQL's performance
From: "Scott Hodson" <scott () ubero ! com>
Date: 2002-06-28 21:13:20
[Download RAW message or body]
This eWeek article is always referred to when MySQL is compared to other
commercial systems that are faster. Does anybody have any other
articles to support this? If it's really faster there needs to be other
studies or other benchmarks done to support this. MySQL doesn't even
show up on the TPC benchmarks, a long-time set of database benchmarks.
http://www.tpc.org/
They probably aren't even considered in TPC because MySQL has
historically had weak transaction support, though the TPC-H benchmark
has to do with queries only.
Also, the eWeek article seems to only consider Java applications using
MySQL, instead of overall speed, independent of the speed of any
language or its database connection drivers.
We did our own benchmark comparing SQL Server with 3 different JDBC
drivers (Microsoft, JDBC-ODBC, and JSQLConnect) and MySQL with 2
different JDBC drivers (MM and Resin) and the Resin/MySQL combination
was the fastest. But using .NET and SQL Server was even faster. It was
a benchmark with a bunch of queries, no transactions.
-----Original Message-----
From: Jeff Kilbride [mailto:jeff@kilbride.com]
Sent: Friday, June 28, 2002 1:05 PM
To: Dave Morse
Cc: java@lists.mysql.com
Subject: Re: SubQueries and Temp Tables
So, since MySQL keeps pace with Oracle and beats several other
enterprise systems performance-wise:
http://www.eweek.com/article2/0,3959,293,00.asp
you're saying there are 100% Java databases that "run circles" around
Oracle? I'm sure you'll come up with some lame-ass excuse as to why the
eWeek article is incorrect.
--jeff
----- Original Message -----
From: "Dave Morse" <davem405@attbi.com>
To: "'Arthur Fuller'" <artful@rogers.com>; "'Frank Gates'"
<fgates@yahoo.com>
Cc: "'Paul DuBois'" <paul@snake.net>; <java@lists.mysql.com>
Sent: Friday, June 28, 2002 11:39 AM
Subject: RE: SubQueries and Temp Tables
> You are kidding right? There are several 100% Java databases that run
> circles around MySQL in performance. No big deal there. It isn't the
> language as much as the design and implementation that determines
> performance when it comes to an application as complex as an RDBMS.
>
> Dave
>
> > -----Original Message-----
> > From: Arthur Fuller [mailto:artful@rogers.com]
> > Sent: Thursday, June 27, 2002 2:35 PM
> > To: Dave Morse; 'Frank Gates'
> > Cc: 'Paul DuBois'; java@lists.mysql.com
> > Subject: Re: SubQueries and Temp Tables
> >
> >
> > In database apps, most often the only important criterion is speed.
> > C and
> > C++ are fast, Java is slow. This is not rocket science. If
> > you have to
> > deliver a crosstab result from 5 million rows in a second and half,
> > your alternatives are few. Duh!
> >
> > Arthur
> >
> > ----- Original Message -----
> > From: "Dave Morse" <davem405@attbi.com>
> > To: "'Frank Gates'" <fgates@yahoo.com>
> > Cc: "'Paul DuBois'" <paul@snake.net>; <java@lists.mysql.com>
> > Sent: Thursday, June 27, 2002 1:56 PM
> > Subject: RE: SubQueries and Temp Tables
> >
> >
> > > Original Q was; Why do Java developers use C-based file systems to
> > > develop applications? You can draw any point you want from it.
> > > However, if the only answer is it doesn't matter from a
> > > connectivity point of view then I don't think I'll get an answer.
> > > So what?
> > >
> > > > -----Original Message-----
> > > > From: Frank Gates [mailto:fgates@yahoo.com]
> > > > Sent: Thursday, June 27, 2002 10:49 AM
> > > > To: Dave Morse
> > > > Cc: 'Paul DuBois'; java@lists.mysql.com
> > > > Subject: Re: SubQueries and Temp Tables
> > > >
> > > >
> > > > Well, then what is the point of your question?
> > > >
> > > >
> > > > Dave Morse wrote:
> > > >
> > > > > Why write a web browser or anything in Java?
> > > > >
> > > > > Same reasons (answers) apply to the application server,
> > > > database backend
> > > > > side.
> > > > >
> > > > > Regardless of what it is written in a Java app can probably
> > > > connect to
> > > > > it but that isn't the point.
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Paul DuBois [mailto:paul@snake.net]
> > > > > > Sent: Thursday, June 27, 2002 8:04 AM
> > > > > > To: Dave Morse; java@lists.mysql.com
> > > > > > Cc: 'MySQL'
> > > > > > Subject: RE: SubQueries and Temp Tables
> > > > > >
> > > > > >
> > > > > > At 7:12 -0700 6/27/02, Dave Morse wrote:
> > > > > > >NO - mine is a honest question. An "open source" server
> > > > in C and a
> > > > > > >client in Java makes sense, I guess to some.
> > > > > >
> > > > > >
> > > > > > I guess I'm not sure why it wouldn't make sense. If
> > > > you're running a
> > > > > > Web browser that's written in Java, do you require a Web
> > > > server to be
> > > > > > written in Java before you'll connect to it?
> > > > > >
> > > > > > >
> > > > > > >> -----Original Message-----
> > > > > > >> From: Paul DuBois [mailto:paul@snake.net]
> > > > > > >> Sent: Wednesday, June 26, 2002 5:37 PM
> > > > > > >> To: Dave Morse; 'Arul'; java@lists.mysql.com
> > > > > > >> Cc: 'MySQL'
> > > > > > >> Subject: RE: SubQueries and Temp Tables
> > > > > > >>
> > > > > > >>
> > > > > > >> At 7:16 -0700 6/26/02, Dave Morse wrote:
> > > > > > >> >MySQL is barely an SQL database - it doesn't support
> > > > > > >> much basic SQL 89 >functionality. Can any one throw
> > > > > > >> some light on why
> > > > > > professional SQL
> > > > > > >> >database developers want to use it for anything but
> > > > simple file
> > > > > > >> >management? AND It is written in C as well so why do
> > > > > > Java developers
> > > > > > >> >use it?
> > > > > > >>
> > > > > > >> Given that the server is a separate program than Java
> > > > developers
> > > > > > >> would write *clients* for, why would it matter in the
> > > > least what
> > > > > > >> language the server is written in.
> > > > > > >>
> > > > > > >> You're trolling, right?
> > > > > > >>
> > > > > > >> >
> > > > > > >> >Regards,
> > > > > > >> >
> > > > > > >> >Dave
> > > > > > >> >
> > > > > > >> >> -----Original Message-----
> > > > > > >> >> From: Arul [mailto:arulkumar@calsoft.co.in] >>
> > > > > > >> Sent: Tuesday, June 25, 2002 9:05 PM >> To:
> > > > > > >> java@lists.mysql.com >> Cc: MySQL
> > > > > > >> >> Subject: SubQueries and Temp Tables
> > > > > > >> >>
> > > > > > >> >>
> > > > > > >> >> Hi All
> > > > > > >> >>
> > > > > > >> >> I am currently porting our application from
> > > > Oracle to MySQL.
> > > > > > >> >> We have some subqueries in oracle which cannot be
> > > > ported into
> > > > > > >> >> MySQL.We even
> > > > > > >> >> tried some joins which didnt work out..
> > > > > > >> >>
> > > > > > >> >> So Could anyone throw some light on Temporary
> > > > tables.Is this
> > > > > > >> >> the right way
> > > > > > >> >> to do it..
> > > > > > >> >>
> > > > > > >> >> Since our main query is dependent on the
> > inner query we
> > > > > > >> >> thought we could
> > > > > > >> >> run
> > > > > > >> >> the inner queryfirst and create a temp
> > > > table.Then we could
> > > > > > >> >> have a join
> > > > > > >> >> between the main table and the inner table.
> > > > > > >> >>
> > > > > > >> >> Is this advisable..
> > > > > > >> >>
> > > > > > >> >> Any other better options?
> > > > > > >> >>
> > > > > > >> >> Regards,
> > > > > > >> >> -Arul
> > > > > > >> >>
> > > > > > >> >>
> > > > > > >> >>
> > > > > > >> >>
> > > > > > >>
> > > > > >
> > > >
> > --------------------------------------------------------------------
> > -
> > > > > > >> >> Please check
> > > > > > >> >> "http://www.mysql.com/Manual_chapter/manual>
> > > > _toc.html" before
> > > > > > >> >>
> > > > > > >> >> posting. To request this thread, e-mail
> > > > > > >> >> java-thread3890@lists.mysql.com
> > > > > > >> >>
> > > > > > >> >> To unsubscribe, send a message to the address
> > shown in the
> > > > > > >> >> List-Unsubscribe header of this message. If you
> > > > cannot see it,
> > > > > > >> >> e-mail java-unsubscribe@lists.mysql.com instead. >>
> > > > > > >> >
> > > > > > >> >
> > > > > > >> >
> > > > > > >>
> > > > > >
> > > >
> > >-------------------------------------------------------------------
> > >--
> > > > > > >> >Before posting, please check:
> > > > > > >> > http://www.mysql.com/manual.php (the manual)
> > > > > > >> > http://lists.mysql.com/ (the list
archive)
> > > > > > >> >
> > > > > > >> >To request this thread, e-mail
> > > > > > <mysql-thread113047@lists.mysql.com>
> > > > > > >> >To unsubscribe, e-mail
> > > > > > >> <mysql-unsubscribe-paul=snake.net@lists.mysql.com>
> > > > > > >> >Trouble unsubscribing? Try:
> > > > > > >> http://lists.mysql.com/php/unsubscribe.php
> > > > > > >>
> > > > > > >>
> > > > > >
> > > > >
> > > > >
> > > >
> > --------------------------------------------------------------------
> > -
> > > > > Please check
> > > > "http://www.mysql.com/Manual_chapter/manual> _toc.html" before
> > > >
> > > > > posting. To request this thread, e-mail
> > > > java-thread3910@lists.mysql.com
> > > > >
> > > > > To unsubscribe, send a message to the address shown in the
> > > > > List-Unsubscribe header of this message. If you cannot see it,
> > > > > e-mail java-unsubscribe@lists.mysql.com instead.
> > > >
> > > >
> > >
> > >
> > >
> > >
> > --------------------------------------------------------------------
> > -
> > > Please check
> > "http://www.mysql.com/Manual_chapter/manual> _toc.html" before
> >
> > > posting. To request this thread, e-mail
> > java-thread3918@lists.mysql.com
> > >
> > > To unsubscribe, send a message to the address shown in the
> > > List-Unsubscribe header of this message. If you cannot see it,
> > > e-mail java-unsubscribe@lists.mysql.com instead.
> > >
> >
> >
> > --------------------------------------------------------------------
> > -
> > Please check
> > "http://www.mysql.com/Manual_chapter/manual> _toc.html" before
> >
> > posting. To request this thread, e-mail
> > java-thread3920@lists.mysql.com
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail java-unsubscribe@lists.mysql.com instead.
> >
> >
>
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
> before posting. To request this thread, e-mail
> java-thread3927@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it, e-mail
> java-unsubscribe@lists.mysql.com instead.
>
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
before posting. To request this thread, e-mail
java-thread3932@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it, e-mail
java-unsubscribe@lists.mysql.com instead.
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail java-thread3935@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail java-unsubscribe@lists.mysql.com instead.
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic