The transcoder errors are, sorry to say, bad input data. The transcoder is telling you the value it has encountered in the codec is illegal for that field. It will do the best it can but either is either damage or bad conversion artifacts.
as for the slow queries, there is one manual way to do it without the GUI.
Should that fail, there is nothing which can be done. It’s either the processor or something else at the system level.
