Re: Loading png images into a mysql table/database
- From: "seaside" <seaside.ki@xxxxxxx>
- Date: 22 Dec 2006 16:28:32 -0800
seaside schrieb:
eholz1 schrieb:
Hello Members,
I am setting up a photo website. I have decided to use PHP and MySQL.
I can load jpeg files into the table (medium blob, or even longtext)
and get the image(s) to display without a problem.
Just a small performance note:
Additionally, here is a bit more on MySQL:
- The query cache of MySQL is OFF by default. On a production system,
you should turn it on,
Since this might return significant better performance.
- You should keep all your queries in a separate module and call
function of this module from everywhere in your web-app.
Note, that MySQL only uses the query cache, if queries are absolutely
identical. Even if one character is lower-case in one query and
upper-case in the other, MySQL assumes them to be different. Same
applies to white-space.
.
- References:
- Loading png images into a mysql table/database
- From: eholz1
- Re: Loading png images into a mysql table/database
- From: seaside
- Loading png images into a mysql table/database
- Prev by Date: Re: monitor file (inode) changes effectively, how?
- Next by Date: Re: can any PHP framework match Ruby On Rails clarity of design?
- Previous by thread: Re: Loading png images into a mysql table/database
- Next by thread: Re: Loading png images into a mysql table/database
- Index(es):
Relevant Pages
|
