Any way of increasing a mysql view performance when you can't use the merge algorithm.
Posted on 2011-09-29
Long story short, I created a view that utilizes a UNION ALL and does some math operations. I am aware that this means I cannot use the Merge algorithm for the view, but the performance is pretty bad using the temptable algorithm.
I really need to use this view because it makes the coding so much easier for our developers. Are there any suggestions on improving the performance or possibly an alternative to using the temptable algorithm? I would be open to switching database platforms (postgre maybe?) or change the server configuration, adding resources to the server, etc.