Answer the question
In order to leave comments, you need to log in
How to store PDF files?
There is a task: to make storage for PDF files. There are already more than 3000 files. And every day their number increases by 20pcs.
Need quick access and content search.
Inside the files, mostly text, but the weight can be different. What will be the options? To push in SQL? Doesn't the base get sick of this? And what about content search?
Answer the question
In order to leave comments, you need to log in
You need a file storage - to choose from. Putting binary files into the database is not recommended in 99% of cases.
Files can be stored in a database, and profit can be made from this, for example, in supporting a transactional model of work, including with files, in obtaining consistent backups, etc.
For example, MS SQL stores files inside the database quite well (there is a special data type - filestream ) and indexes them perfectly - fts out of the box .
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question