Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Opinions on storing binary data in a database

Author  Topic 

obz
Starting Member

2 Posts

Posted - 2005-05-31 : 17:39:13
Hello,

I'm looking at possibly restructuring our postgres database to include binary data (which is currently being served separately). The binary files (and there are hundreds) are about 1-5M in size.

Can anyone who has already done this suggest some pros and cons to doing this? Just looking for some opinions on this type of solution.

Thanks
~obz

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-05-31 : 18:12:06
You should post your question on a web site where they answer questions about postgres databases.

This site is for Microsoft SQL Server questions.


CODO ERGO SUM
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2005-05-31 : 18:23:43
For SQL Server, we generally reccomend storing files outside of SQL Server.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-05-31 : 18:25:13
try the postgres forums at www.dbforums.com.



-ec
Go to Top of Page

obz
Starting Member

2 Posts

Posted - 2005-06-01 : 10:01:42
Thanks. I was looking for more conceptual based responses, if it is good practice or not to store files outside or inside.
Go to Top of Page
   

- Advertisement -