Should I store Images in MySQL — OZONE Asylum, home of the Mad Scientists

FAQ

Should I store Images in MySQL

This page's ID: 5704

You are editing "Should I store Images in MySQL"

Who can edit an FAQ?	Anyone registered may edit an FAQ.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	One word: No! Short Explanation: Storing images in a database is at least 10 times slower when retrieving than storing just a filename which then get's delivered by the webserver. Longer explanation: Ok, Step one: For every image, you'll need an additional query. It will have to be read of the mysql server, transported to your webservers memory, pushed out to the user's browser and then thrown away in your webserver memory. Repeat ad nausaum. Now, if it's stored as a file, it's faster to begin with (no database queries, and filesystems are really really fast, nowadays), plus it will also be cached in your webservers memory if it's asked for a lot making it as fast as the line will take it. [small][i](Added by: [url=http://www.ozoneasylum.com/cgi-bin/ubbmisc.cgi?action=getbio&UserName=Tyberius+Prime]Tyberius Prime [/url] on Fri 20-Jun-2003)[/i][/small] Loading...
Options:	Enable Slimies Enable Linkwords

« Backwards — Onwards »

Show Forum Drop Down Menu