Re: Re:pulling audio out of a blob and playing it. => just a question about performance

2001-03-27 Thread roger westin

Just since the subject was brought up...
Im going to relseas Lucas Web Server V2.0 in a few weeks, it stores
everything (htmlfiles,
images etc) in the DB. To add to the adv/dis list:
Advantages
---
Content management (for communites and larg corp)

Dis
--
Content magangment (for others)

/roger



> (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
>
>

-
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




Re:pulling audio out of a blob and playing it. => just a question about performance

2001-03-27 Thread Filip Sergeys

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