我觉得在sql中存储文件路径而不是blob更好.这是真的？如果我们必须扩展软件,我们仍然应该遵循这种方法.
关于这个主题,有一篇很好的微软白皮书,here.
objects smaller than 256K are best stored in a database while objects larger than 1M are best stored in the filesystem. Between 256K and 1M,the read:write ratio and rate of object overwrite or replacement are important factors
当然,他们的结论特定于sql Server(2005和2008 R2).
