Text storage

Question

I work on a job site (using asp.net 3.5) in which a user can upload one or more resumes. Database - SQL Server 2005. What is the recommendation for storing these documents? Should I store it as a blob in the database or just save the path in the database and save the document in a physical folder? Can anyone mention the pros and cons of each performance and scalability?

Thanks!

Answer 1

Storing files in a database gives you:

(+) simplifies housekeeping, no orphan files on disk

(+) consistent programming and access model (authorization)

(-) , .

, , . , ( , , ).

Answer 2

. , ( ) .

, , . , . Microsoft Research . , .

, , Microsoft SharePoint Word ( ) SQL Server . .

Answer 3

, - ( ​​ , ..) , . , ( 21 . /) db, , .

Answer 4

Simple Recovery Model. , , .

Answer 5

, , - , 20 . (, 2008-01, 2008-02), , , .

/ . / /, , . , 10-20K 1-2K. .

Answer 6

, . , , , . , .

:

• , .
• / .
• , - .., .

Answer 7

, .

, , , SQL . (.ndf) , , BLOB.

, , (1) , - . (2) . (3) OLTP.

Answer 8

:

• .
• .

: , .., Word, .

, : , (, , ).
.

I would also normalize the file names at the time of sending so that they are consistent, for example 20090219-001.doc.

Like others, you can parse a doc file to extract pure text information and store it in a database to take advantage of text search.