I'm trying to port an application from SQL Server to MySQL (5.6.4) and running into performance issues. MySQL happens to be running on OS X Server, but this seems more like a UNIX question. SELECT ...

What is window function vs subquery in SQL? In summary, subqueries and window functions are used for different purposes in SQL, and each has its strengths and weaknesses.