Speed impact of DB when use filestream

I have simple question for everyone. We save attachments to a database directly. Table with attachments has terrible 92GB, complete database has 137GB. We are thinking about moving attachments to filestream from database.

Has anybody experience with this? Is there any speed impact to the DB?

Thanks a lot.

This is what MSDN says:

The size and use of the data determines whether you should use database storage or file system storage. If the following conditions are true, you should consider using FILESTREAM:

  • Objects that are being stored are, on average, larger than 1 MB.
  • Fast read access is important.
  • You are developing applications that use a middle tier for application logic.

For smaller objects, storing varbinary(max) BLOBs in the database often provides better streaming performance.

I cannot say I would see a database to perform worse when attachments were stored in the filesystem. On the other hand, the storage will be used anyway, does not matter if it is stored inside the database or not. So personally I would stick with the recommendations from Microsoft.