[opencms-dev] Holding Database Connection and Performance Issue.

[Joe Desbonnet]

Unless you have a dedicated high bandwidth connection linking your app
server and DB, I would strongly recommend that you try to host your
database and app server as close as possible (ie in the same room or
building).

With a long distance standard internet link (no matter how fast) you
are likely to have periods where you will suffer some network
congestion and packets will be dropped.  Even a fraction of a percent
packet loss is likely to have a huge negative impact on your site
performance.

The stale connection problem is likely to be a different problem. Can
you post the exception to the list?

Joe.



On 8/29/06, RAJ <rajparikh7575 at gmail.com> wrote:
>
> Hi All,
>       I've installed openCMS on websphere 6.0 environment, database we are
> using is 8i. Our Application server resides on west coast of USA, and
> database is on east coast.
>       My problem here is :
>
>       1. OpenCMS Keep holding the database connection, after one or two days
> website goes down and it throws stale database connection exception.
>           Once we reset the connection pool it works fine for another 2 or 3
> days and start throwing same exception.
>
>       2. Web site is too slow, it take more then a minute to load single
> page is is because of, my database is on east cost and my application is
> hosted on west cost ?
>
> Thanks
> Rupesh
>
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>