[Solved] MySQL: Update query taking time to execute

kevinf
 
on Jul 10, 2022 11:32 PM
294 Views

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? 

Download FREE API for Word, Excel and PDF in ASP.Net: Download