Do you really want to put 100,000 files into one database file? Isn't that
a bit risky? Why not use Firebird to store an index to the file location on
some other storage mechanism and focus on it doing the job as a relational
management system, but the physical storage for the files could then be
stored on multiple redundant disk drives?

Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org

> -----Original Message-----
> From: Raigo [mailto:raigo77@...]
> Sent: Monday, October 04, 2004 9:47 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] File/document managament on Firebird
>
>
> I need to develop a file and document managament system. My question:
> would it be a good idea to store all files in Firebird BLOB?
>
> I can see two possible ways:
> 1)all files are in BLOB
> 2)files are in (windos) filesystem and there is a link
> (filename) stored
> in FB
>
> What would be better?
>
> I already have a system of over 100000 images in BLOB - no speed
> problems at all. But this one is going to be much bigger and
> mainly will
> be storing Office (.doc, .xls. ppt), Acrobat (.pdf), AutoCAD (.dwg)
> files (probably will be used for even more formats).
>
> Has someone here developed some file/document management system on
> FB/IB? is it possible to see it? How does its data model look like?
>
> Any advice would be more than welcome.
>
>
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>