Text in DB? (How to search a large amount of text?)
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.
Any ideas?
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.
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
GBs
I've used FullText Search once before. I don't know about saving all this text in the database. I worked on another project and we saved the chapter texts in the database, I think.
I'll think about it some more.