Hello,
We've decided to use dot Lucene for full-text searching our database (sql 2000)
, and we've got no idea what practise is best: Storing files on the filesystem, or in the database.
The table holding the files will contain quite a lot of files. 20 000 or so.
Does anyone know what the advandages / disadvantages there are by storing files on disk, or in the database?
Does storing files in the database cause decreased performance?
If anyone have got links to articles discussing this issue, or have a good explanation of the differences between these 2 stragegies, I would appreciate it
Thanks for your help!