… MachineName SETUP A: We have a web application that uses MS SQL database. When invoking a SELECT statement in LogDetails table(having…: Red Hat Linux 4 Memory: 512MB QUESTION: 1) Why does MS SQL performs faster when they have the same specs though with… can affect the performance but why has it not affected MS SQL much compared with MYSQL? 3) Any suggestions on how to…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
June 7, 2007 By 117 Comments
… the problem. Unfortunatelly I’ve never dealt with MS SQL and moverover never had bosses who love MS SQL, so I am useless here.
Comment: MySQL wins C'T Database Contest
August 31, 2006 By 27 Comments
… very nice chart clearly showing that Oracle, DB/2 and MS SQL are far behind, and MySQL is the fastest server on… – with transactions. I have around 10 yrs of Informix and MS SQL (yes, it’s a shame, I know) administration. And as…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
June 7, 2007 By 117 Comments
… question is how can I convince my boss to trash MS SQL. MS Tortures me 
.
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… run (and still can’t) most of your Oracle/DB2/MS SQL Queries on MySQL because subqueries optimizer weakness. I’m saying… users would like. These features are often small, typically not SQL Standard compatible but help you if you’re web developer…
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
…-6276-a-closer-look/3. We have applied it to MS SQL Server, not to MySQL yet, but it is the same…
Comment: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
…’s unbelievable how bad the mysql query execution engine is. MS SQL, Oracle and even Postgres do not have problems like this…
Comment: Will Percona Support Drizzle ?
August 8, 2008 By 10 Comments
… to move to Linux/Unix – is shop moving away from MS SQL for cost reason having no Linux experience but years of…
Comment: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 30, 2008 By 17 Comments
Yeah this is great stuff. I recall that MS SQL Server would actually figure out that a table and its …
Comment: Using CHAR keys for joins, how much is the overhead ?
November 12, 2007 By 18 Comments
I believe this is true from across the database environments; be it MS-SQL or MySQL or ORACLE or DB2 or any other.
