|
|
Posted by seaside on 12/23/06 00:28
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.
Navigation:
[Reply to this message]
|