Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Problem with performance when using Stored Routines i.c.w. ORDER BY or Temp Table

pascalvgemertpascalvgemert EntrantInactive User Role Beginner
I already posted my question on Stackoverflow:
http://stackoverflow.com/questions/19638949/mysql-query-slow-because-of-order-by-with-stored-functions

The problem appears when I try to use the results of the Stored functions in the ORDER BY. I also tried to store the result (without the ORDER BY) in to a temporary table, but ended up with the same result. The query runs fast if I remove the ORDER BY.

Any directions are very welcome, thanks!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.