我希望我可以在数据库中存储和检索声音。 [英] I wish I could store and retrieve Sound to and from database.

问题描述

嗨


我不想改变我的名字或任何东西:)但我希望我能将Sound保存到SQL服务器并检索它


所以我的问题是如何将一个wav文件保存到SQL服务器中以及如何检索它


非常感谢

Lisa Jone

Hi

I dona??t want to change my name or anything :) but I wish I was able to save Sound into SQL server and retrieve it

So my question is How do you save a wav file into a SQL server and how do you retrieve it

Thanks so much

Lisa Jone

推荐答案

本文介绍如何存储图像，但blob是一个blob http://www.vbdotnetheaven.com/Code/Sept2003/2175 .asp


然而，无论你是否想这样做都是另一回事。你会发现

有很多人试图将大量的BLOB数据存储在

数据库中而只是为了找到它杀死的性能...... br />
" Lisa Jones" <一个******* @ discussions.microsoft.com>在留言中写道

新闻：7D ********************************** @ microsof t.com ...

This article shows you how to store images, but a blob is a blob
http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp

However, whether or not you want to do this is another story. You''ll find
quite a few people with tales of woe trying to store a lot of BLOB data in a
DB only to find it killed performance...
"Lisa Jones" <an*******@discussions.microsoft.com> wrote in message
news:7D**********************************@microsof t.com...

嗨

我不想改变我的名字或任何东西:)但我希望我能够
保存声音进入SQL服务器并检索它。
所以我的问题是你如何将一个wav文件保存到SQL服务器中以及如何检索
？
非常感谢

Lisa Jones

Hi

I don''t want to change my name or anything :) but I wish I was able to save Sound into SQL server and retrieve it.
So my question is How do you save a wav file into a SQL server and how do you retrieve it?
Thanks so much
Lisa Jones

为什么不将文件路径存储到数据库，然后将文件保存到路径中。这将有助于保持数据库大小下降并加快数据库查找


格伦

Why not store the file path to the DB and then save the file to the path. This would help to keep the DB Size down and speed up DB lookups

Glenn

我和你在一起100％ 。我发布了一个关于如何做到这一点的链接，但我真的认为这是'b $ b恶意建议，除非它是一个loooowww流量数据库，即便如此，它也是很多

更容易将它存储在驱动器上，你可以获得附带的好处，即无需编写大量代码即可访问它。

Glenn Wilson ; <一个******* @ discussions.microsoft.com>在消息中写道

news：64 ********************************** @ microsof t.com ...

I''m with you 100%. I posted a link on how to do it but I really think it''s
ill advised unless it''s a loooowww traffic db, and even then, it''s a lot
easier to store it on a drive and you get the side benefit of being able to
access it without writing a good bit of code.
"Glenn Wilson" <an*******@discussions.microsoft.com> wrote in message
news:64**********************************@microsof t.com...

为什么不将文件路径存储到数据库，然后将文件保存到路径中。
这将有助于降低数据库大小并加快数据库查找速度。
Glenn

Why not store the file path to the DB and then save the file to the path. This would help to keep the DB Size down and speed up DB lookups.
Glenn

这篇关于我希望我可以在数据库中存储和检索声音。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！