MySQL Performance Blog: Can we get faster _expression_ handling in MySQL
Andrew from Sphinx continues to work on improving SQL (or SphinxQL) support and now he published benchmarks comparing arithmetic _expression_ handling in Sphinx to one in MySQL. The result ? Sphinx scored 3x to 20x faster. Andrew goes to explain results are not 100% comparable (as we can see in the table results are even different) and some performance can be attributed to Sphinx using different typing for _expression_. Though I’m wondering how much of Performance difference that really explain. I doubt it is 20x. Andrew goes on to explain there are further optimizations possible for Sphinx such as JIT compilation and _expression_ optimization which he claims can increase the lead even further
Andrew is kind enough to provide explanations and benchmark results though this is far from the first notion of this problem I hear about. Many other companies looking to optimize MySQL problem, especially in analytics space when expressions should be computed over hundreds of millions of rows have expressed their concerns with this part of MySQL execution. I’m wondering if we’re going to see any improvements in this space by Oracle, MariaDB or Drizzle. I think Drizzle is in advantage here – with simplifying MySQL functionality a lot they probably can also simplify _expression_ handling to be faster.
Entry posted by peter | No comment
Add to: |
|
|
|
URL: http://www.mysqlperformanceblog.com/2010/03/30/can-we-get-! faster-_expression_-handling-in-mysql/
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
