4 Replies Latest reply on May 14, 2014 4:33 AM by Mohsen esfandiary

    filling db pool connection is very slow

    Mohsen esfandiary Newbie

      Hi

       

      i'm using jboss as 7 as application server and my database is informix(IDS 11)

      when i start jboss , filling db pool connection is very slow.

      for 2000 connection (min-pool-size=2000) time about 4 minutes required.

      but if i replace DB2 as my default database ,  this problem does not exists.

      can everybody help me?

      thanks

       

       

      this is my datasource configuration :

       

                         <datasource jta="true" jndi-name="java:jboss/datasources/InformixDS" pool-name="infx_Pool" enabled="true"  use-java-context="true" use-ccm="true">

                              <connection-url>jdbc:informix-sqli://60.1.2.41:12010/novelcore:INFORMIXSERVER=vjinformix;IFX_LOCK_MODE_WAIT=2;DB_LOCALE=cs_CZ.852;CLIENT_LOCALE=cs_CZ.852</connection-url>

                              <driver>informix</driver>

                              <pool>

                                  <min-pool-size>500</min-pool-size>

                                  <max-pool-size>500</max-pool-size>

                                  <prefill>true</prefill>

                              </pool>

                              <security>

                                  <user-name>novel</user-name>

                                  <password>nnnnovel</password>

                              </security>

                              <validation>

                                      <validate-on-match>true</validate-on-match>

                                      <background-validation>true</background-validation>

                              </validation>

                              <timeout>

                                  <blocking-timeout-millis>30000</blocking-timeout-millis>

                                  <idle-timeout-minutes>5</idle-timeout-minutes>

                              </timeout>

                          </datasource>