RE: MySQL

2006-10-19 Thread Anthony
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

Re: MySQL

2006-10-19 Thread Clinton Begin
OhI 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 an

RE: MySQL

2006-10-19 Thread Dorin Manoli
  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

Re: MySQL

2006-10-19 Thread Clinton Begin
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

Re: MySQL

2006-10-19 Thread Brian Kierstead
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 s

Re: MySQL

2006-10-19 Thread Clinton Begin
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)

MySQL

2006-10-19 Thread Dorin Manoli
iBATIS is slower with MySQL provider that MSSQL .. does anyone accouter such problem?

Re: iBATIS , results in DataGrid

2006-10-19 Thread Larry Meadors
Just moving this to the appropriate list... On 10/19/06, Dorin Manoli <[EMAIL PROTECTED]> wrote: Hi! I'm doing now an application and I map my results to the IList. But it is messy to assign results to DataGrid (.Net v1.1) Now I'm doing: ……. for(int i=0; i