[newbie] How to minimize DB load?

Vincent Delporte wrote:
> On Wed, 06 Dec 2006 21:34:14 -0500, Jerry Stuckle
> <jstucklex@attglobal.net> wrote:
>
>>A persistent connection is one which hangs around - that is, when you
>>close the connection, it doesn't really "close" it - as in it doesn't
>>disconnect from MySQL.
>
>
> OK. I was wondering what the difference was between mysq_connect() and
> _pconnect().
>
> So, to minimize load, the first step is making sure the DB schema +
> queries are prestine, and then, try to make as few calls as possible.
> Short of using an application server instead of CGI like PHP, there's
> not much I can do on a shared server?

Actually, you wouldn't want an application server as much as a database
server. An application server won't reduce database load.

It sounds like you need to optimize something. But what you need to do
and how to do it is very much dependent on your application and MySQL;
it's really impossible to give any but the broadest guidelines.
However, you should read the MySQL doc to understand more of what's
happening. And you can get some good database-related answers in
comp.databases.mysql.

And if you can't reduce the load any more, you may have to go with a
more expensive package shared hosting package, a virtual private server
or even a dedicated server.

But the first thing should be to talk to your host and get more details
on why they believe this is the case.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Thu, 07 Dec 2006 06:58:15 -0500, Jerry Stuckle
<jstucklex@attglobal.net> wrote:
>Actually, you wouldn't want an application server as much as a database
>server. An application server won't reduce database load.

Yup, looks like it. I'll see if we can a better arrangement regarding
access to the MySQL database.

Thank you.