Re: Performance issue on dedicated server

On Jan 8, 2008 4:46 PM, Panayiotis Dionyssopoulos <pdion-Pa7mVGAsjv/[email protected]>
wrote:

>
>
>
>
> "Normal Xaraya error processing has stopped because of an error
> encountered.
>
> The last registered error message is:
> PHP Error code: 2
> At:
> /var/www/vhosts/eurobath.gr/httpdocs/xaradodb/drivers/adodb-mysql.inc.php
> (Line: 355) mysql_connect(): Too many connections
>
> "
>
> while other times the site is just unresponsive.


I believe there is a setting to use either persistent or non-persistent
connections in the config file.  Ensure that you are not using the
persistent connections.  Also, check your auto-cache / sessionless cache
settings.  I believe there is a tutorial on xaraya.com that gives some good
guidance on the subject.  My guess is with the increased traffic, you are
also seeing a spike of spider traffic.

The problem with any framework is for flexibility and faster development
time, you tend to have a higher cost in hardware.  I justify this business
case with people cost more than hardware any day of the week, but that's
something that you need to think about just a bit.  For instance:

SELECT foo.bar
             bar.foo
FROM foo foo

LEFT OUTER JOIN bar bar
on foo.bar = bar.bar

is going to be more performance friendly than:

SELECT foo
FROM foo

SELECT bar
FROM bar

but with xaraya you are more apt to see more individual queries than the
joined queries just due to the nature of the beast.  So you are always going
to give up some performance over what could be written on a one-off basis.
Cache should take care of some of the problems, but there is always going to
be the cases where the cache has to be built.

hth a bit,

jc