将视频存储和检索到SQL 2005中 [英] Storing and retrieving video into sql 2005

问题描述

我想将视频存储到数据库中，并且在检索视频时要求在PC中存储路径.

i want to store video into database and at the time of retrieving it ask for path to store in pc.

推荐答案

我能提供的最佳建议是不要这样做".

视频占用大量空间，SQL2005的最大数据库大小限制为1TB-这不是很多视频！

而是将视频存储在HDD上，并将视频的路径存储在DB中.

即使使用更高版本的SQL Server(可以容纳更大的数据库)，我还是强烈建议您这样做，因为插入和选择操作会占用大量带宽！

The best advice I can give is "Don''t do it".

Video takes a lot of space, and SQL2005 is limited to a maximum database size of 1TB - that is not a lot of videos!

Instead, store videos on a HDD, and store the path to the video in the DB.

Even with later version of SQL server (which can hold much bigger databases) I would strongly recommend that this is a poor idea as insert and select operations will use serious amounts of bandwidth!

这篇关于将视频存储和检索到SQL 2005中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！