… the case when buffer allocation was a bottleneck – with dependent subselect with order by – but in that case this was to…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 57 Comments
… write the queries, some of them it turn used subqueries subselects and derived tables. It is also very dangerous if you…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… slower at connection creation and MySQL is very fast, while SubSelect optimization is very bad in MySQL for many cases until…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… prepared not to mention other issues. I’m saying about SubSelects which were added in MySQL 4.1 but you still…
Comment: MySQL - to use or not to use
May 31, 2007 By 10 Comments
… reporting queries is needed as MySQL often fails to optimize subselects properly only able to use nested loops join method this…
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 9, 2007 By 22 Comments
… out – in some cases you would benefit from using 2 subselects in FROM clause and joining them together. The problem is…
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 8, 2007 By 22 Comments
… this more, to only return one one column on the subselect and leftjoin the same table back in I found gave…
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 6, 2007 By 22 Comments
… a temp table then join against that. This was before subselects… Even worse is that joins with blobs that are never…
Post: Feature Idea: Finding columns which query needs to access
November 17, 2006 By 16 Comments
… sum it up, not to mention more complex questions of subselects. It would be great tool for MySQL Performance Optimization if…
Comment: Derived Tables and Views Performance
August 31, 2006 By 16 Comments
… would explain the speed difference). Probably the execution of the subselect is faster/less of a memory hog than creating the…
