BLOB vs FileSystem [英] BLOB vs FileSystem

问题描述

虽然这个问题已经出现在前一篇文章中，但是不同的场景和不同的考虑决定哪一个最好。

我需要实现一个系统，每年可以处理200GB-400GB大小的图像（大约每个图像1mb）。这是P& C图像，只允许授权的个人访问和查看。我计划使用一个基于系统的应用程序，以INSERT到MYSQL数据库，并使用PHP基于Web的应用程序仅用于VIEW。

我想使用FILESYSTEM，因为它很容易做备份&在图像上恢复，无需担心MYSQL数据库的大小。

我使用在Windows Server中运行的MySQL + Apache + PHP。 b
$ b

您的建议和意见非常感谢。

谢谢。

问候，
Desmond

解决方案

小于256K的对象最好存储在数据库，而大于1M的对象
最好存储在文件系统中。在256K和1M之间，
的读写比率和对象覆盖率或替换率是
的重要因素。

源：
http://research.microsoft.com /apps/pubs/default.aspx?id=64525

编辑：这是MS SQL，所以MAYBE与Mysql相同：）

Although this question has been appear in past previous post, but different scenario and different consideration decide which one is the best.

I need to implement a system whereby it can handle 200GB - 400GB size of images yearly(approximately < 1mb per image). It is P&C images which only allowed for authorised personal to access and VIEW only. I am planning to use an application based of system to INSERT to MYSQL database and using PHP web based application for VIEW only.

I am thinking to use FILESYSTEM because it is easy to do backup & restore on the images and no need to worry on the size of the MYSQL database.

I am using MySQL + Apache + PHP running in Windows Server.

Your advice and input is very much appreciated.

Thank you.

Regards, Desmond

解决方案

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.

souce: http://research.microsoft.com/apps/pubs/default.aspx?id=64525

Edit: It is MS SQL, so MAYBE same as Mysql :)

这篇关于BLOB vs FileSystem的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！