The sql statements are straight forward so I'm very skeptical that the problem is JBoss Cache cache loader. Can you turn logging level to debug and extract the sql statment going to the database then try to run it within informix client to see if the database itself is taking long to handle blobs? Also Can you try a different version of the jdbc driver. It might be the way the jdbc driver is handling blobs causing the slowness you're seeing. Finally, as Bela said you can change the cloumn types and even the create statement for the jboss cache table, if non of the above turned out better results. This will tune the sql statment better for informix.
- Hany View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3913974#3913974 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3913974 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
