(I think) most people figure that the disadvantages of having images and
most other binary files stored within the DBMS far outweigh any
advantages. From the top of my head...
Advantages
----------
- tidiness
- ease of backup - all data is in one respository.
Disadvantages
-------------
- DB is bigger, therefore repairs/checks/etc take longer (?)
- for website apps, you can have your binary files (eg
images/wavs) stored under the web heirarchy, meaning that a mysql
application is not required to retrieve the file from disk.
I'm sure there's more...I'm a bit short of time at the moment!
P
On Tue, 27 Mar 2001,
Filip Sergeys wrote:
> Hi
> Just a question. What about performance when storing audio files in a blob.
> What effect does it have on the database(load, space requirements compared to
> audio files,...) I will be confronted with this question in the near future
> where I will have to decide to store on disk or in blob. I you have some
> statistics, can you provide them?
>
> Thanks in advance.
>
> FS
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php