RE: [PHP] Speed of Images from DB
| From: | Matthew Loff | Date: | Fri, 30 Nov 2001 22:10:10 +0000 |
| Subject: | RE: [PHP] Speed of Images from DB | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-76263@lists.php.net to get a copy of this message | ||
It would be mighty handy for MySQL to have a binary file column type,
like Oracle, where the file was stored externally, outside of the rest
of the table data... Anyone heard of any plans to implement this?
-----Original Message-----
From: Julio Nobrega Trabalhando
[mailto:inerteARROBAhotmail.com@pb1.pair.com]
Sent: Friday, November 30, 2001 12:18 PM
To: php-general@lists.php.net
Subject: Re: [PHP] Speed of Images from DB
> But that could be due to server capabilities of my ISP (if he has for
> example a high tech mysql-server and a relativly slow machine for
apache).
Probaly :-)
From this page:
http://www.mysql.com/information/presentations/presentation-oscon2000-20
0007
19/
You can read on section 'General tips':
- Store BLOB's that you need to access as files in files. Store only the
file name in the database.
But I guess it also depends on the image size.
--
Julio Nobrega
Don't eat the yellow snow.
"Stefan Rusterholz" <scripting@interaktion.ch> wrote in message
news:000701c179bb$33c4df30$3c01a8c0@quasimodo...
> I did do that for a galery-script of myself. I don't have any numbers
if
> you'r looking for that but my personal impression was, that the
picture
> output from the mysql-db is actually faster than reading directly from
disk.
> But that could be due to server capabilities of my ISP (if he has for
> example a high tech mysql-server and a relativly slow machine for
apache).
>
> But with a quite fast mysql-server it shouldn't be a problem I think.
>
> And if it _would_ be a problem, I think there are still more positive
> aspects then negatives (easy handling, having stored all important
> informations together, fast searching of images with keywords and so
on)
>
> best regards
> Stefan Rusterholz, s.rusterholz@interaktion.ch
> ----------------------------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net