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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote:iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter such problem?
