I have an ASP.Net/C# application with SQL Server 2014.
I created a table and in one of the columns, I save plain text. This is , for example, some pages text from a book. The column is varchar(max). This table has multiple rows.
In the ASP.Net application, I have a search button and user can enter a keyword and I search this table and find the text and display it This works ....
But by saving large amount of text in the database, the size of the database grows. How can I go about doing this text search?
One idea that I thought of is to save the text in , for example, text files and then search the text files with iTextsharp maybe.