Re: Creating Sort Index Slow
I would ...
- move the table to InnoDB
- optimise the server for InnoDB (http://mysql.rjweb.org/doc.php/memory)
- normalise the table, starting by projecting all columns with incrementing digits in their names (eg rem0, ..., rem49) out to keyed child tables
- change doubles to decimals to get rid of rounding errors
- write specific Select Expression lists rather than Select *.
Subject
Views
Written By
Posted
41672
March 14, 2014 09:59PM
15866
March 17, 2014 11:59AM
10839
March 17, 2014 08:20PM
Re: Creating Sort Index Slow
8185
March 17, 2014 08:46PM
6790
March 17, 2014 10:31PM
5384
March 18, 2014 01:13AM
5098
March 19, 2014 04:56PM
4789
March 19, 2014 05:04PM
4083
March 19, 2014 10:06PM
7216
March 19, 2014 11:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.