Skip to main content
I
ItAllSpins
Participant
January 12, 2009
Question

Maximum Number of JDBC Datasources

  • January 12, 2009
  • 1 reply
  • 677 views
Does anyone know if there is a limit or if there is a recommended max to the number of JDBC datasources that a standard version of CF8 can handle?

We have approx. 500 on our server and occasionally the server restarts due to Out of Memory errors. This most recently happened when adding a new datasource through the CF Admin, which is what led me to asking this question.

Thanks, Chris
    This topic has been closed for replies.

    1 reply

    N
    Newsgroup_User
    Inspiring
    January 12, 2009
    > Does anyone know if there is a limit or if there is a recommended max to the
    > number of JDBC datasources that a standard version of CF8 can handle?
    >
    > We have approx. 500 on our server and occasionally the server restarts due to
    > Out of Memory errors. This most recently happened when adding a new datasource
    > through the CF Admin, which is what led me to asking this question.

    A datasource is just a bunch of setting which get stuck in an XML file.
    THey don't have any RAM footprint in and of themselves.

    However, the more DSNs you have, it suggests the more DB traffic you have,
    and indeed probably more activity on the box.

    How much RAM have you got allocated to the JVM?

    Have you used FusionReactor or similar to monitor what's going on with the
    RAM the JVM has?

    --
    Adam
    I
    ItAllSpinsAuthor
    Participant
    January 12, 2009
    Thanks for the response....we have 768MB allocated to JVM. I've tried more and CF wouldnt even start up, so 768 was the max I was comfortable allocating.

    Our memory usually sits between 50% - 70%, but under load it goes up to 90%. We have FusionReactor, which is how I got those #'s, but unfortunately crash protection doesnt prevent crashes. Memory goes up, a few requests get queued, and then the server restarts.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices