A new version of the Google Site Search module for Joomla 2.5 was published get more infos here.

IT-Blog

Troubles with OracleDataSource

We have a very nice Java-Application at our side, and wanted to speed up the performance with the OracleDataSource (before we were working with Standard JDBC).

oracle.jdbc.pool.OracleDataSourceSo we tested a lot and the performance was slightly better in the test-environment than before.After that we went to production with it.... and the phones began to rang, the performance was BAD BAD BAD Cry

After 3 hours of analyzing of our sourcecode we had the solution:

                        Caching is not enabled by default  (suprise surprise... by Oracle)

After adding  additionals lines

        <jdbc-connection-pool datasource-classname= "oracle.jdbc.pool.OracleDataSource" ...>
        <property name="ImplicitCachingEnabled" value="true"/>
        <property name="MaxStatements" value="190"/>
        </jdbc-connection-pool>

We had an incredible speed up! 

The application is now about 10 times faster than before using this DataSource.  If it is possible in any case use this Datasource!

 


    Veröffentlichen Sie ihre Kommentare ...


    Warning: Creating default object from empty value in /www/htdocs/w0101274/www/fairtec.at/modules/mod_udjacomments/helper.php on line 387