I wanted to save/store a voice message in SQL Server,
and BLOB is the data type that I'd thought about but
never been used it. Do you have any best practice or
suggestion on this subject?
Thanks.You need an ActiveX to listen to your audio. The datatype to use on SQL is image. And you can use ADO.Stream to read/write the file.|||Thanks rdjabarov,
If using the Image data type, and since each audio message is only between 9k ~ 18K, is using the text in row (ON) will improve the performance, or the text in row (OFF), which saved the audio file outside of SQL Server is
better?
SVT|||You'll benefit from TEXT_IN_ROW only with TEXT data type, when you're storing "clear" text into it. In other words, when you SELECT from a table with this setting on, the optimizer doesn't need to read the pointer value and then go to the BLOB pages to retrieve the actual value of the field. In your case it's a binary file, so you shouldn't bother with this setting.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment