Re: Limited connections to the database. .

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Norland, Martin wrote:

http://www.google.com/search?q=oracle+limit+client+connections

http://www.oracle.com/technology/pub/articles/php_experts/scaling_oracle
_and_php.html

Summary - either you're not using persistent connections, or your site
is just very busy.  If it's just that the site is busy, best you can do
is just limit things on the website end.  If the problem is no
persistent connections - then you'll want to switch them on if you're
doing multiple queries/page.  You also want to make sure any information
that doesn't need to be pulled from the database isn't (perhaps there
are some global settings/etc. that change once a month, cache them
globally somewhere and don't keep requesting them so often) - there may
not be any such data, but then again, there may be.

cheers,
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257

The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.


-----Original Message-----
From: Marcos R. Cardoso [mailto:mcardoso@xxxxxxx] Sent: Monday, October 17, 2005 5:37 AM
To: php-db@xxxxxxxxxxxxx
Subject:  Limited connections to the database. .

Hello to everyone,

we have been using an Apache server here at work (I work in a Library) where PHP/ASP scripts query the database very frequently (in the near future only PHP scripts will be used). The DBAs have recently complained

that our webserver is performing the queries in a high speed and many times in a second. It worried them and they are asking if we could limit

the connections to the database to a low number. As an example they told

us that other applications in other webserver uses Tomcat to run Java, and there they managed to limit the number of active connections at the same time.

I would like to know if it's possible to make something similar, and I'd

like to know too if we have to configure the PHP or the Apache.

Our environment is listed below:

Windows 2003 Server
Apache 2.0.54
PHP 4.4.0
Sun Chili!Soft ASP 3.6.2
MySQL 4.0.20a
Oracle 9i (through a Oracle 8i NetClient)


TIA,
Marcos R. Cardoso
Blumenau
Brazil

I was wondering if anyone thought managing multiple DBs in one script was feasible, let alone efficient?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux