MySQL

Thread: MySQL

Search this list only Search all lists
MySQL
	2006-10-19 14:46:39

iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter such problem?
MySQL
	2006-10-19 16:07:46

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 < Dorin.Manolidataireland.ie">Dorin.Manolidataireland.ie> wrote: iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter such problem?
MySQL
	2006-10-19 16:10:29

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: mail.gmail.com" type="cite"> 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 < Dorin.Manolidataireland.ie">Dorin.Manolidataireland.ie> wrote: iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter such problem?
MySQL
	2006-10-19 16:13:56

It could be the driver for sure...but really, how different is the 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 < brianfluidmedia.com">brianfluidmedia.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: mail.gmail.com" type="cite"> 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 < Dorin.Manolidataireland.ie" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Dorin.Manolidataireland.ie> wrote: iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter such problem?
MySQL
	2006-10-19 16:35:03

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.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 < brianfluidmedia.com">brianfluidmedia.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 < Dorin.Manolidataireland.ie" target="_blank">Dorin.Manolidataireland.ie> wrote: iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter such problem?
MySQL
	2006-10-19 16:51:49

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 < Dorin.Manolidataireland.ie">Dorin.Manolidataireland.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.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 < brianfluidmedia.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">brianfluidmedia.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 < Dorin.Manolidataireland.ie" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Dorin.Manolidataireland.ie> wrote: iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter such problem?
MySQL
	2006-10-20 02:49:04

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.begingmail.com] Sent: Thursday, October 19, 2006 9:52 AM To: user-csibatis.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 <dataireland.ie">Dorin.Manolidataireland.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.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 <fluidmedia.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">brianfluidmedia.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 <dataireland.ie" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Dorin.Manolidataireland.ie> wrote: iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter such problem?

[1-7]

about | contact Other archives ( Real Estate discussion Medical topics )