We have tableArticle(id, user_id, date_created, date_from, date_to, title, description, latitude, longitude)If we were to separate the title and description data into another table like this, how significantly would searching improve if we had 10,000,000 articles. ArticleContent(article_id, title, description)What is the cruical factor here that would increase searching speed noticeably? ** UPDATE **
- by searching i mean full-text search
- title: varchar(50), description: TEXT
- mysql version 5.5
- storage engine used innoDB ( So no fulltext search support )