在SQL Server 2008 r2数据库中保存图像的限制是什么？ [英] What is the limit for saving images in SQL server 2008 r2 database?

问题描述

我在设计一个表格作为处方，用数据提供，然后捕获并打印，并将捕获的图像保存在数据库中作为图像。

但我害怕数据库增长，当我将每个处方保存为图像时（数年后）数据库达到大小限制，

以这种方式保存处方是否正确？或者有更好的方法来保存处方以随时检索和打印。



我尝试过的方法：



最好将处方内容保存为一个单元格中的分隔字符串（由（$$）之类的任何符号分隔），当用户尝试检索处方时，程序会分开单元格内容（将每个$$设为一个新行）并将它们绘制到要打印的表单中？

I'm thinking in design a form as prescription, feed it with the data, then capture it and print, and save captured image in the database as image.
But i'm afraid of database growth when i save every prescription as image in it(after years) database reach a size limit,
Is that right to save the prescriptions by this way? or there is a better way to save the prescription to retrieve and print it at any time.

What I have tried:

Is that better to save the prescription content as seperated strings in one cell(separated by any sign like ($$)), when user try to retrieve a prescription the program seperate the cell content (make every $$ a new line) and draw them to the form to print?

推荐答案

）），当用户尝试检索处方时程序分开单元格内容（使每个

)), when user try to retrieve a prescription the program seperate the cell content (make every

一个新行）并将它们绘制到要打印的表单？

a new line) and draw them to the form to print?

SQL Server的理论最大数据库大小为524272TB。

SQL Server的最大容量规格 [ ^ ]



显然，数据库不能大于你的可用存储容量，这几乎肯定要低几个数量级。



如果您使用的是Express版本，则每个数据库进一步限制为10GB数据。 （这不包括 FILESTREAM [ ^ ]数据或日志文件。）



如评论中所述，最好的方法仍然是在文件系统中存储文件。但是如果输出足够简单以便重新创建，那么在数据库中存储重新创建它所需的原始数据也会有效。

SQL Server has a theoretical maximum database size of 524272TB.
Maximum Capacity Specifications for SQL Server[^]

Obviously, a database cannot be larger than your available storage capacity, which will almost certainly be several orders of magnitude lower.

If you're using the Express edition, each database is further limited to 10GB of data. (This does not include FILESTREAM[^] data or log files.)

As mentioned in the comments, the best approach remains to store files in the file system. But if the output is simple enough to recreate, storing the raw data needed to recreate it in the database would also work.

这篇关于在SQL Server 2008 r2数据库中保存图像的限制是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！