哪个数据库适合存储图像和视频? [英] What database is good for storing Images and Videos?
问题描述
在我的项目中，我需要上传我的图像和视频，如果我将其存储在Mysql数据库中，则这些文件会被上传
In my project i need to upload my images and videos , those files if i store on Mysql database it gets
获取这些图像的速度很慢.所以我将这些文件存储在某个文件夹中并将这些Path存储在db.Its good，但
slow on get those images.So i store those files on some folder and store those Path on db.Its good , but
我需要知道是否有任何数据库可以存储图像和视频，并以有效的方式对其进行处理?
i need to know is there any database to store images and videos , and process those in effiecient way ?
HBASE是否适合这样做?如果这就是为什么我们需要这个庞大的数据库来存储图像和视频的原因?请
Is HBASE is good for that?if it is why we need this huge database for storing images and videos ? Please
弄清楚这个疑问.
推荐答案
选择最有效的环境来处理Blob不是一件容易的事.这取决于很多因素.请参阅本文，该论文仅针对NTFS和SQL Server 2005进行了研究.您可以在那里阅读，这完全取决于您的个人情况.顺便说一句，这是2006年，当时BLOB支持是一个新功能.今天不要将这些数字用作您的设置！它仅应说明该主题的复杂性.
Choosing the most efficient environment for serving blobs is not a trivial task. It depends on a lot of factors. See this paper which made a research only for NTFS and SQL Server 2005. As you can read there it depends absolutely from your personal situation. BTW this was 2006 when BLOB support was a fresh feature. Don't take those number for your setting today! It should just illustrate the complexity of this topic.
我的建议是继续使用您熟悉的DBS，并使用其BLOB数据类型和流式api.这将为您提供一个很大的优势，您不必关心ACID，复制和其他备份策略.我的猜测是，如果使用得当，您将不会感到需要任何性能上的改进.例如.如果您手动将SQL Server存储在文件系统中，则SQL Server的Filestream类型将为您提供相同的性能.
My advice is stay with the DBS you feel comfortable with and use its BLOB datatype and a streaming api. This will give you the big advantage that you don't have to care about ACID, replication, a further backup strategy. My guess is that if used properly you won't feel any need for a performance improvement. E.g. SQL Server's Filestream type will give you the identical performance if you'd store it manually in the filesystem.
如果您谈论的是高容量/高频率数据，那当然是一个完全不同的故事.
It is of course a complete different story if you are talking about high volume/frequency data.
这篇关于哪个数据库适合存储图像和视频?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
