Posted by Bernd Kohler on 05/28/05 11:38

Thanx!!
But what do you mean by caching the queries?
I'm already using many JOINs to keep the number of queries as low as
possible.
What do you think about the session-variables? Can they be handled quick
enough or will they slow down the server?

>
> First off 3.x is not the MySQL installation you should be using. 4.0 or
> 4.1 you should be using now. Also your PHP installation is dated where
> PHP is at version 4.3.11.
>
> Now as for users, I have never had MySQL break down. I also have 50
> websites that run off of one database with one administration panel. These
> sites get fairly heavy traffic.
>
> Now what you should pretty much do is Cache your queries so you are not
> always querying the database. Only query when you need to. Make use of
> JOIN statements, so you are not constantly querying for data that could be
> in one query. Sometimes these JOINs can get a bit messy because some of
> them are INNER JOINS some are LEFT OUTER JOINS etc.. And you end up with a
> paragraph long query. But simply, it runs much faster.
>
> Make sure you have index's on certain id's and things you will be looking
> up regularly such as usernames and passwords, this allows you to do an
> index query. These are normally very quick.
>
> Also as for the connection limit on MySQL you can change the threshold on
> that in the config file. Also you might want to think about reusing your
> connection PConnect. For me this works much better, but for some they
> experience problems.
>
> Mike

[Back to original message]