Hi,
I can't help but think that Tom Kyte, Oracle guru, has a really good take on this:
"You have my advice, you want data protected, secure, manageable, restored to a point in
time -- you be using a database."
I agree with him - keep the files in the database, and configure it accordingly. Those
interested in knowing more about his rationale may want to read
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:232814159006#41255803210007
Regards,
Georger
--- Em sex, 12/9/08, German Pizarro <gpizarro1977@stripped> escreveu:
> De: German Pizarro <gpizarro1977@stripped>
> Assunto: Re: SV: File Uploads larger than 1mb
> Para: "Lista Eventum Usuarios" <eventum-users@stripped>
> Data: Sexta-feira, 12 de Setembro de 2008, 12:27
> OK, here is the deal:
>
> Files need to be attached to issues. Where to keep them?
>
> First and Obvious, with such a topic, anyone will stand for
> their own personal preferences and maybe argument "this
> is better beacause..."
> Plz, let's not do that since I might take comments that
> differs from mine as a personal attack and I'll find out
> where you live! :)
> Let's keep it as objective as possible and debate the
> alternatives.
>
> Databases were not originally designed to store files...
> but in practice actually they do, an eventually large ones.
>
> I don't endorse any, however, since file storing is not
> a database-design-feature but instead a collateral feature,
> we are just taking advantage of it (the classic hammer-screw
> metaphor).
>
> We can debate and do a lot of talking (and metaphors) on
> how good this approach could be ("today's hammers
> can handle screws just fine", "using screw drivers
> is the old way to nail screws, use a hammer instead").
>
> Some approach might even have advantages over the other
> ("it' easier to smash it than screw it")
> however we'll have to deal with some minor
> "issues".
>
> Assuming we NEED to store LARGE files within Eventum
> (don't ask why, arguments could be Eventum versatility
> or whatever), let's discard that subject (actually, I
> don't even store medium-size files in my Eventum).
>
> In the theoretical suposition we could choose (who said we
> could vote anyway? ;) I see 3 alternatives for Eventum
> implementation:
> -attachments stored in database (today's
> implementation)
> -attachments stored in file-system (alternative
> implementation)
> -attachment stored in one of the 2 previous, choose the one
> that fits best at install time (ideal-world implementation).
>
>
> Regards
>
Novos endereços, o Yahoo! que você conhece. Crie um email novo
> com a sua cara @ymail.com ou @rocketmail.com.
http://br.new.mail.yahoo.com/addresses
