Search Posts

Mysql Select on Longtext datatype takes infinite time with just 10k Records

how to – Mysql Select on Longtext datatype takes infinite time with just 10k Records

I have created a table with a column for content with datatype as LONGTEXT. While running select query with this column, it takes infinite time.

I have tried running some indexes including FULLTEXT index.

What alternative do i have to overcome this problem?

Source: Stackoverflow

Leave a Reply

Your email address will not be published. Required fields are marked *