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?
|
