Avoiding lots of connections?

[Anon]

Right now I have php script that returns text blobs from a database, this script gets called a ton and is passed an id of a field and just retuns the text..

What I am wondering if there is a way to do like COM (type) objects for php/mysql so instead of opening new connections everytime that script is called that it would use an existing one and maybe speed/clean things up.

Right now it is not a problem but i guess it could potentially be one?

Let me know what input or opinions you have, thanks.

[Anon]

Hi Ryan,

You may try to connect to the database using MTS connections which reduces the total no. of connections being made to the database resulting in better utilization of resources.

Also, keep the SQL / PL/SQL code in a procedure and pin it (Always in the Cache!) in the SGA.

Hope this helps.

Arul.