You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by Dorin Manoli <Do...@dataireland.ie> on 2006/10/19 16:46:39 UTC
MySQL
iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter
such problem?
Re: MySQL
Posted by Ted Husted <hu...@apache.org>.
I've seen a post for someone who is working around that by splitting
the database over multiple servers. Evidentally, there's nothing in
the license agreement that prevents that sort of things. I believe it
was on Euan Garden's blog, but it seems to be down this morning.
http://blogs.msdn.com/euanga/archive/2006/03/09/545576.aspx
Other items Euan's blog (when it comes back up) might assuage some
managerial concerns.
-Ted.
On 10/31/06, Dorin Manoli <Do...@dataireland.ie> wrote:
>
> Yes. I'm evaluating it now. It is good enough. Unfortunately my managers
> aren't happy, don't know why, I think they are afraid by database size
> limitation.
> On 10/19/06, Dorin Manoli <Do...@dataireland.ie> wrote:
> > Thanks dude. ! I agree with you, cause of costs cut, we decided to
> move to a
> > free database.
>
> Have you tried SQL Server Express?
>
> * http://msdn.microsoft.com/vstudio/express/default.aspx
>
> -T.
-- HTH, Ted.
* http://www.husted.com/struts/
RE: MySQL
Posted by Dorin Manoli <Do...@dataireland.ie>.
Yes. I'm evaluating it now. It is good enough. Unfortunately my managers
aren't happy, don't know why, I think they are afraid by database size
limitation.
On 10/19/06, Dorin Manoli <Do...@dataireland.ie> wrote:
> Thanks dude. ! I agree with you, cause of costs cut, we decided to
move to a
> free database.
Have you tried SQL Server Express?
* http://msdn.microsoft.com/vstudio/express/default.aspx
-T.
Re: MySQL
Posted by Ted Husted <hu...@apache.org>.
On 10/19/06, Dorin Manoli <Do...@dataireland.ie> wrote:
> Thanks dude. ! I agree with you, cause of costs cut, we decided to move to a
> free database.
Have you tried SQL Server Express?
* http://msdn.microsoft.com/vstudio/express/default.aspx
-T.
RE: MySQL
Posted by Anthony <an...@mevspc.com>.
There are definitely performance gains by using MS SQL or Oracle for
that matter over MySQL. But taking a performance hit for cost sometimes
can be justified. Even though you are using the same queries, sometimes
they will often not run the same (as far as query execution) across
different DBMS servers. Sometimes tweaking a query differently on
different DBMS will make one out perform the other and vice versa. The
only time I have ever gotten MySQL to crash was with poor queries. MySQL
also does offer Enterprise versions, which I have never tinkered with,
they __COULD__ essentially be the same code base, but Enterprise may
have some enhancements to survive Enterprise level datasets.
Just my 2 cents.
I am new to iBatis, but so far, in my usage, it beats the crap out of
the relational mapper we are currently using at my work (Wilson OR
Mapper)
-----Original Message-----
From: Clinton Begin [mailto:clinton.begin@gmail.com]
Sent: Thursday, October 19, 2006 9:52 AM
To: user-cs@ibatis.apache.org
Subject: Re: MySQL
Oh....
I forgot to mention...MySQL crashed after 48 million rows.
I'm willing to accept that I may not have configured MySQL perfectly for
performance, or possibly not even for the stability needed for a dataset
of that size.
I guess the point is that, out of the box, SQL Server worked very well
and MySQL didn't.
Cheers, :-)
Clinton
On 10/19/06, Dorin Manoli <Do...@dataireland.ie> wrote:
Thanks dude. ! I agree with you, cause of costs cut, we decided to move
to a free database. So the same data , same indexes, same query are much
more slower on MySQL than SQL 2005
I came back and start to tune my.cnf parameters.. got some speed, but
still a crap..
Actually I have MySQL .Net provider . I use iBATIS for a Windows
application..
I'm not even close to JDBC..but I can see what is it performance,
because MySQL QueryBrowser and Admin are using java and JDBC and they
are hanging up very ofen :-(
It could be the driver for sure...but really, how different is the
<http://ADO.NET> ADO.NET driver from the JDBC driver? I'd imagine
they're very similar.
Also, I'd be surprised if Microsoft wrote a driver for a competing
technology that's better than one of the most popular database/platform
combinations in the world (Java/MySQL).
I really think it's just the database. I tried both MyISAM and InnoDB.
SQL Server 2005 Developer Edition just destroyed them both.
Cheers,
Clinton
On 10/19/06, Brian Kierstead <br...@fluidmedia.com> wrote:
Is it MySQL or JDBC that is slower? I've never used it JDBC, but I know
that ODBC is noticeably slower.
Brian
Clinton Begin wrote:
Other than that MySQL is a heck of a lot slower than MSSQL, no. :-)
I recently loaded the netflix prize data (100,000,000 rows), and using
cached prepared statements, batch updates, with transactions from 1000 -
10,000 records at a time.....
MSSQL was 3x faster than MySQL using JDBC (so not ADO.NET), but same
difference.
Cheers,
Clinton
On 10/19/06, Dorin Manoli <Do...@dataireland.ie> wrote:
iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter
such problem?
Re: MySQL
Posted by Clinton Begin <cl...@gmail.com>.
Oh....
I forgot to mention...MySQL crashed after 48 million rows.
I'm willing to accept that I may not have configured MySQL perfectly for
performance, or possibly not even for the stability needed for a dataset of
that size.
I guess the point is that, out of the box, SQL Server worked very well and
MySQL didn't.
Cheers, :-)
Clinton
On 10/19/06, Dorin Manoli <Do...@dataireland.ie> wrote:
>
>
>
> Thanks dude. ! I agree with you, cause of costs cut, we decided to move to
> a free database. So the same data , same indexes, same query are much more
> slower on MySQL than SQL 2005
>
> I came back and start to tune my.cnf parameters.. got some speed, but
> still a crap..
>
> Actually I have MySQL .Net provider . I use iBATIS for a Windows
> application..
>
> I'm not even close to JDBC..but I can see what is it performance, because
> MySQL QueryBrowser and Admin are using java and JDBC and they are hanging up
> very ofen L
>
>
>
>
>
>
> It could be the driver for sure...but really, how different is the ADO.NETdriver from the JDBC driver? I'd
> imagine they're very similar.
>
> Also, I'd be surprised if Microsoft wrote a driver for a competing
> technology that's better than one of the most popular database/platform
> combinations in the world (Java/MySQL).
>
> I really think it's just the database. I tried both MyISAM and InnoDB.
> SQL Server 2005 Developer Edition just destroyed them both.
>
> Cheers,
> Clinton
>
> On 10/19/06, *Brian Kierstead* <br...@fluidmedia.com> wrote:
>
>
> Is it MySQL or JDBC that is slower? I've never used it JDBC, but I know
> that ODBC is noticeably slower.
>
> Brian
>
>
>
> Clinton Begin wrote:
>
>
> Other than that MySQL is a heck of a lot slower than MSSQL, no. :-)
>
> I recently loaded the netflix prize data (100,000,000 rows), and using
> cached prepared statements, batch updates, with transactions from 1000 -
> 10,000 records at a time.....
>
> MSSQL was 3x faster than MySQL using JDBC (so not ADO.NET), but same
> difference.
>
> Cheers,
> Clinton
>
> On 10/19/06, *Dorin Manoli* <Do...@dataireland.ie> wrote:
>
> iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter
> such problem?
>
>
>
>
>
>
>
RE: MySQL
Posted by Dorin Manoli <Do...@dataireland.ie>.
Thanks dude. ! I agree with you, cause of costs cut, we decided to move
to a free database. So the same data , same indexes, same query are much
more slower on MySQL than SQL 2005
I came back and start to tune my.cnf parameters.. got some speed, but
still a crap..
Actually I have MySQL .Net provider . I use iBATIS for a Windows
application..
I'm not even close to JDBC..but I can see what is it performance,
because MySQL QueryBrowser and Admin are using java and JDBC and they
are hanging up very ofen :-(
It could be the driver for sure...but really, how different is the
ADO.NET <http://ADO.NET> driver from the JDBC driver? I'd imagine
they're very similar.
Also, I'd be surprised if Microsoft wrote a driver for a competing
technology that's better than one of the most popular database/platform
combinations in the world (Java/MySQL).
I really think it's just the database. I tried both MyISAM and InnoDB.
SQL Server 2005 Developer Edition just destroyed them both.
Cheers,
Clinton
On 10/19/06, Brian Kierstead <br...@fluidmedia.com> wrote:
Is it MySQL or JDBC that is slower? I've never used it JDBC, but I know
that ODBC is noticeably slower.
Brian
Clinton Begin wrote:
Other than that MySQL is a heck of a lot slower than MSSQL, no. :-)
I recently loaded the netflix prize data (100,000,000 rows), and using
cached prepared statements, batch updates, with transactions from 1000 -
10,000 records at a time.....
MSSQL was 3x faster than MySQL using JDBC (so not ADO.NET), but same
difference.
Cheers,
Clinton
On 10/19/06, Dorin Manoli <Do...@dataireland.ie> wrote:
iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter
such problem?
Re: MySQL
Posted by Clinton Begin <cl...@gmail.com>.
It could be the driver for sure...but really, how different is the
ADO.NETdriver from the JDBC driver? I'd imagine they're very similar.
Also, I'd be surprised if Microsoft wrote a driver for a competing
technology that's better than one of the most popular database/platform
combinations in the world (Java/MySQL).
I really think it's just the database. I tried both MyISAM and InnoDB. SQL
Server 2005 Developer Edition just destroyed them both.
Cheers,
Clinton
On 10/19/06, Brian Kierstead <br...@fluidmedia.com> wrote:
>
>
> Is it MySQL or JDBC that is slower? I've never used it JDBC, but I know
> that ODBC is noticeably slower.
>
> Brian
>
> Clinton Begin wrote:
>
>
> Other than that MySQL is a heck of a lot slower than MSSQL, no. :-)
>
> I recently loaded the netflix prize data (100,000,000 rows), and using
> cached prepared statements, batch updates, with transactions from 1000 -
> 10,000 records at a time.....
>
> MSSQL was 3x faster than MySQL using JDBC (so not ADO.NET), but same
> difference.
>
> Cheers,
> Clinton
>
> On 10/19/06, Dorin Manoli <Do...@dataireland.ie> wrote:
> >
> > iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter
> > such problem?
> >
>
>
>
Re: MySQL
Posted by Clinton Begin <cl...@gmail.com>.
Other than that MySQL is a heck of a lot slower than MSSQL, no. :-)
I recently loaded the netflix prize data (100,000,000 rows), and using
cached prepared statements, batch updates, with transactions from 1000 -
10,000 records at a time.....
MSSQL was 3x faster than MySQL using JDBC (so not ADO.NET), but same
difference.
Cheers,
Clinton
On 10/19/06, Dorin Manoli <Do...@dataireland.ie> wrote:
>
> iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter
> such problem?
>