Jacco wrote:Quite probably correct, but there can be a lot of reasons why it takes this> Hi,
> Every time, I create a connection to mySQL server, it takes about 3 seconds
> before the connection is made. The server is at the other side of a VPN
> connection, so this might cause the delay.
long. You need to find out why - it shouldn't take 3 seconds.
This is a general rule, not an absolute fact. And opening/closing the> Anyway, reading the newsgroups, I learned that it is not wise to create a
> connection and keep that open for the entire time the app is running. So, I
> create a connection, do the query and close the connaction again. Every time
> with this delay.
connection for each query is definitely NOT the way to go! You need to find a
happy medium there.
It wouldn't help you unless you have multiple applications running on the client> What can be the solution to this issue? I read some things about connection
> pooling, but it's hard to find doentation about it.
and accessing the same mysql server.
You need to figure out why the delay in connecting/disconnection and resolve it
(if you can). You also need to plan your application a little better to create
a balance between connections and performance.
Remove the "x" from my email address
JDS Computer Training Corp.