comment on

Keep in mind while its pretty cool to keep images and binary data in a database these solutions may be prone to scalability issues (at the very least, its inefficient).

To store binary data in a database you've got two hits:

Reading the data from the database
The database reading the data from the disk

The general solution employed is to have a pointer in the database pointing to your file in the filesystem.

Now what you have is a considerable reduction of data in the database which may easy be cached in memory, resulting in a performance increase.

Of course I'm generalising here, there are always exceptions.. :-)

In reply to OT: Images into MySQL database by Ryszard
in thread Images into MySQL database by cidaris

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Clear questions and runnable code get the best and fastest answer
	PerlMonks