WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  Statement cache size

    Posted Wed August 11, 2010 10:36 AM
    Statement cache size

    --------------------------------

    Any bad impact if I set Statement cache size (WebSphere Application Server data source properties) to a too high value like 100. ?

    Thanks in advance.

    --------------------------------

    Posted By: johny_z at Mar 2 2009 10:25AM


  • 2.  Statement cache size

    Posted Wed August 11, 2010 10:44 AM
    Can anybody please help me on this?
    Thanks.

    [quote=johny_z;7599]Any bad impact if I set Statement cache size (WebSphere Application Server data source properties) to a too high value like 100. ?

    Thanks in advance.[/quote]


    --------------------------------

    Posted By: johny_z at Mar 10 2009 9:01AM


  • 3.  Statement cache size

    Posted Wed August 11, 2010 10:49 AM
    Statement Cache size in WebSphere

    --------------------------------

    Try this link: www-03.ibm.com/systems/resources/systems...

    It might be helpful.

    --------------------------------

    Posted By: texaco at Mar 10 2009 3:40PM


  • 4.  Statement cache size

    Posted Wed August 11, 2010 10:49 AM
    thanks very much for your precious information

    --------------------------------

    Posted By: johny_z at Mar 23 2009 3:15PM


  • 5.  Statement cache size

    Posted Wed August 11, 2010 11:01 AM
    The higher cache size you set the more memory it will need. Make sure you ask your developer use PreparedStatements instead of other Statement. Use Resource Analyzer to tune this variable. Hope this help.

    --------------------------------

    Posted By: tonycao at Apr 21 2009 7:40PM


Related Content