Re: [PHP] BLOB - PHP Peformance DB vs. Web server Opinions

2003-12-04 Thread Sophie Mattoug
Ahbaid Gaffoor wrote: Thanks to all who helped with my earlier questions on pulling BLOB data out of Oracle using PHP. I am however finding that performance is slow when downloading huge files from the database. A typical 2Meg GIF file being downloaded from Oracle via. PHP is taking about

RE: [PHP] BLOB - PHP Peformance DB vs. Web server Opinions

2003-12-04 Thread Jay Blanchard
[snip] 2) Is there any advice for or against storing images as blobs in a database? Or is it better to store them on the web server file system? [/snip] Never store images as blobs, never. The read/write operation to the database for these is expensive and unnecessary. Store a reference to the

[PHP] BLOB - PHP Peformance DB vs. Web server Opinions

2003-12-03 Thread Ahbaid Gaffoor
Thanks to all who helped with my earlier questions on pulling BLOB data out of Oracle using PHP. I am however finding that performance is slow when downloading huge files from the database. A typical 2Meg GIF file being downloaded from Oracle via. PHP is taking about thirty seconds.