[jboss-user] [JBossCache] - Re: JDBCCacheLoader bad performance when writing to DB

[gmeroz]

when setting log priority to debug, i get the following. It means that when i add a node to the cache, for each node the same select query is running 4 times. When the cache has thousands of nodes, it's a huge overhead.


  | 16:59:37,992 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/3-CHILDREN-2-2)
  | 16:59:38,007 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/3-CHILDREN-2-2)
  | 16:59:38,007 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/3-CHILDREN-2-2)
  | 16:59:38,007 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/3-CHILDREN-2-2)
  | 16:59:38,007 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/1-SIBLINGS-1-1)
  | 16:59:38,023 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/1-SIBLINGS-1-1)
  | 16:59:38,023 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/1-SIBLINGS-1-1)
  | 16:59:38,023 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/1-SIBLINGS-1-1)
  | 16:59:38,039 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/2-SIBLINGS-440-440)
  | 16:59:38,039 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/2-SIBLINGS-440-440)
  | 16:59:38,054 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/2-SIBLINGS-440-440)
  | 16:59:38,054 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/2-SIBLINGS-440-440)
  | 16:59:38,070 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/2-LOWER-440-440)
  | 16:59:38,070 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/2-LOWER-440-440)
  | 16:59:38,070 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/2-LOWER-440-440)
  | 16:59:38,085 DEBUG [JDBCCacheLoader] executing sql: select node from jbosscache_1 where fqn=? (/aag/queries/d1-1-d2-0-d3-1347132-d4-0-d5-0-d7-6-d9-109-d14-0-d15-0-24-2/2-LOWER-440-440)
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4117380#4117380

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4117380