Re: [PHP] BLOB - PHP Peformance DB vs. Web server Opinions
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 thirty seconds. Everything (database, web server, development box) are all on a 100 Megabit Switched ethernet setup. 1) Are there any pitfalls or guidelines when working with BLOBs and web apps? 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? So far I am finding the web server file system to be faster, but I tend to think that it is less manageable from a relational data perspective. thoughts? thanks Ahbaid Hi For me it's obvious that storing any data (an image a fortiori) in a file is always (please, other list-members, tell if I'm wrong) faster than extracting from a database. Hope this helps, -- Cordialement, --- Sophie Mattoug Développement web dynamique [EMAIL PROTECTED] --- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] BLOB - PHP Peformance DB vs. Web server Opinions
[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 image instead, which can be quickly and easily called. Also, a 2Mb image file...even on an intranet this is just wrong unless you have a need for high-res photos. If someone accessed this on a dial-up it would cause them avery long wait indeed. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] BLOB - PHP Peformance DB vs. Web server Opinions
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. Everything (database, web server, development box) are all on a 100 Megabit Switched ethernet setup. 1) Are there any pitfalls or guidelines when working with BLOBs and web apps? 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? So far I am finding the web server file system to be faster, but I tend to think that it is less manageable from a relational data perspective. thoughts? thanks Ahbaid -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php