[jboss-jira] [JBoss JIRA] Assigned: (JBCACHE-382) JDBC persistance with pojo cache and performance issue. Slow performance after Blob inserted

JDBC persistance with pojo cache and performance issue. Slow performance after Blob inserted -------------------------------------------------------------------------------------------- Key: JBCACHE-382 URL: http://jira.jboss.com/jira/browse/JBCACHE-382 Project: JBoss Cache Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: POJOCache Environment: JDk 1.4.2_06, Linux Pentium 4, Debian distribution, Informix Dynamic Server 9.3 back end(running on a server elsewhere) , Reporter: John Lukar Assigned To: Ben Wang Fix For: POJOCache Attachments: JDBC2CacheLoader.java, JDBC2CacheLoaderTest.java, testJbossCache.tar.gz I turned on JDBC persistance with Informix backend using TreeCacheAOP. The performance numbers are horribly slow. The "jbosscache" table created as part of service startup has the columns "fqn","node","parent" with types varchar(255), blob, varchar(255) respectively. The inserts of my pojo business objects as they are serialized into byte stream by the cache, are taking on the average of 15 seconds for each row. The DB is on another server off of the subnet. denormolizing the pojo object and writing a row out with all pojo fields to non-blob/byte columns as varchar, integers, etc. is a lot faster. Is this going to be the expected behaviour where JDBC persistance of POJO objects using serialized byte stream as default mechanism by TreeCache/AOP is going to be magnitude slower ? Can someone suggest a way to use JDBC persistance and yet make it fast or as fast as file persistance, etc. ? Maybe my own cacheLoader scheme ? I have to use JDBC/informix(vs. sleepycat) in order to not worry about local disk failure issues on persistance and recovery. A remote DB seems to be way. thanks