Keep DB Connection Alive

[Angus SC2]

Hello, I have a connection to a mysql server on my website that I would like
to keep "alive" from when a user first goes to a page that requires the
connection until they close the website

How is it possible to set this up? I do not wish to keep creating the
connection everytime I wish to execute a query.

Thank you
Angus

[Anthony Papillion II]

Angus SC2 <[e-mail]> wrote in message news:31*************@individual.net...

Hello, I have a connection to a mysql server on my website that I would like to keep "alive" from when a user first goes to a page that requires the
connection until they close the website

How is it possible to set this up? I do not wish to keep creating the
connection everytime I wish to execute a query.

Thank you
Angus

Check out mysql_pconnect()

Anthony

[Angus SC2]

"Anthony Papillion II" <ad*****@gmail.com> wrote in message
news:1102393469.8b7d360322c5d16ff32395c49501943e@t eranews...

Check out mysql_pconnect()

Anthony

Ok, thanks, but I did something pretty stupid in the last post and just said
it was a mysql connection so that more people could associate with it, in
fact I am using the Php/java stuff (http://uk.php.net/java) and wish to keep
the JVM alive throughout the session, any ideas?

Thanks
Angus

[Michael Vilain]

In article <31*************@individual.net>, "Angus SC2" <[e-mail]>
wrote:

"Anthony Papillion II" <ad*****@gmail.com> wrote in message
news:1102393469.8b7d360322c5d16ff32395c49501943e@t eranews...

Check out mysql_pconnect()

Anthony

Ok, thanks, but I did something pretty stupid in the last post and just said
it was a mysql connection so that more people could associate with it, in
fact I am using the Php/java stuff (http://uk.php.net/java) and wish to keep
the JVM alive throughout the session, any ideas?

Thanks
Angus

I think you're mixing technologies here. Java is meant to connect with
a running server that stays up and maintains state information. php
doesn't work that way. Typically, Apache runs a thread that interpets
the php code, produces the output, then exits. No state information is
kept from invocation to invocation. They're completely different in how
they work.

Reading the page you posted describes several ways of working with Java
and php. Have you contacted the development teams for them and asked
your question? What you're trying to do doesn't seem to be on their
radar.

--
DeeDee, don't press that button! DeeDee! NO! Dee...

[CJ Llewellyn]

"Angus SC2" <[e-mail]> wrote in message
news:31*************@individual.net...

Hello, I have a connection to a mysql server on my website that I would like to keep "alive" from when a user first goes to a page that requires the
connection until they close the website

How is it possible to set this up?
It's not possible. I do not wish to keep creating the
connection everytime I wish to execute a query.

Your problem is not I suspect creating a connection as latency on LAMP
systems tends to be very low but data persistance.

Try reading up on sessions.