在应用程序中存储文件的最佳选择 [英] Best option for storing files in a app

问题描述

嗨！我正在使用SQL Server 2008的vb6应用程序。这个应用程序是一种CRM，所以我们有一个客户实体，我们想将一些文件附加到每个客户（例如：docx，xl​​sx，jpeg和等等）。该应用程序将由多个用户加入，并且此文件必须可供所有用户使用。我想到的第一个选项是将文件直接存储在数据库SQL中的字节字段中，但由于显而易见的原因，我不相信。另一种选择是简单地存储文件的路径，但在这种情况下，该文件可能不适用于所有用户。

你能否告诉我你最好的方法？我将非常感激！

提前告诉并原谅我生锈的英语！



Cristian

解决方案

这取决于很多因素...

根据我的经验，我建议将文件存储在数据库之外，但是在数据库中存储它们的路径。 / BLOCKQUOTE>

Hi! I'm working in a vb6 app with SQL Server 2008. This app is a kind of CRM, so we have a entity for the customer and we would like to attach some files to each customer (ex: docx, xlsx, jpeg, and so on). The app will be accesed by several users and this files has to be available for all of the users. The first option I was thinking was storing the files directly in the database SQL in a byte field, but for obvious reasons I'm not convinced. Another option was to simply store the path of the file, but in this case the file may not be available for all users.
Could you give me your opinion about the best way to do this? I'll be very grateful!
Tks in advance and excuse my rusty english!

Cristian

解决方案

It depends on many factors...
As per my experience, i'd suggest to store files outside the database, but the path to them in a database.

这篇关于在应用程序中存储文件的最佳选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！