How can I add an index on a field of type textarea? I have added the index with field(32). Which is the part of the field I'd like to index. However, each time we do a Quick Repair and Rebuild. Sugar finds the index but wants to remove and re-add the…

Hey! A client of ours is experiencing some weird slowness issue in Sugar 7.9 running on MySQL 5.7. The problem is caused by some of the sql queries taking an extremely long time which effectively causes many of them to get stacked. This in turn eats up…