----- Original Message -----
From: "Valentin Cozma" <[EMAIL PROTECTED]>
To: "Derby Discussion" <[email protected]>
Sent: Thursday, September 11, 2008 2:04 AM
Subject: derby over internet
Hi,
I am using derby over the internet.
In some cases the application starts (connects to the database) very slow.
I think it's because of the latency ( mobile networks ).
After the application starts, the performance is reasonable.
My application uses prepared statements, there are quite a lot of them. I
think it's because of the prepared statements creation that takes so
loong.
1. Can you give some suggestions for my situation ?
2. Are there some "rules"/good practices for working with derby over the
internet ?
Thank you so much !
Valentin, you need to explain a little more about your setup, people then
may figure out why its slow...
Normally the culprit is when dB's connect... ie when the software opens a
connection to the dB, that is a slow process and thats normally why dB pools
are used.
Good luck...
---------------------------------------------------------------------------
HARBOR : http://www.kewlstuff.co.za/index.htm
The most powerful application server on earth.
The only real POJO Application Server.
See it in Action : http://www.kewlstuff.co.za/cd_tut_swf/whatisejb1.htm
---------------------------------------------------------------------------