I have converted from sql 2014 Server database to MySQL,
I have a table with 6500 records with fields for 15 free format questions and 15 Replies they were varchar(max) and have been changed to LONGTEXT in MySQL
My Problem is its extremely slow to display when I use 3 of the fields to order by - Name, Position, Id also deleting Records is slow.
I have setup an Index Called NameIndx with Name, Position, Id
There is no Primary key (is it required)
What do I need to do to speed up the display?