Search Posts

Author: Anmol G

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