CODEWITHSUNDEEP
.netsql-serverfull-text-searchfiletablevarcharmax
Luis Abreu
Luis Abreu

Reputation: 4570

SQL Server semantic search: varchar(max) vs filetable

According to your experience, what's the best option for performing semantic searches for html, word and pdf files? Should the files be saved in a varchar(max) column or directly on disk (in a FileTable)?

File sizes aren't restricted to a maximum predefined size, but most of them are expected to have more than 1 or 2 MB. We think that we'll be having several thousands docs a month (we might have more than 200k files uploaded a year) and we are interested in getting results from those 3 types of files.

What are your recommendations?

Thanks guys!

Luis

Upvotes: 0

Views: 100

Answers (0)

Related Questions