Actually, the log above is for nodes that were laready in the DB. New nodes
inserted into the DB, result in 8 select qeuries which are exatcly the same.
here is an exmaple of inserting only 2 nodes:
| for (int i=0 ; i<2 ; i++){
| Address a = new Address();
| a.setCity("a"+i);
| a.setZip(i);
| cache.put("cat","x"+i,a);
| }
|
result:
anonymous wrote :
| 17:55:46,094 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/)
| 17:55:46,438 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x0)
| 17:55:46,438 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x0)
| 17:55:46,453 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x0)
| 17:55:46,453 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x0)
| 17:55:46,453 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x0)
| 17:55:46,469 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x0)
| 17:55:46,469 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x0)
| 17:55:46,485 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x0)
| 17:55:46,563 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=?
(/__JBossInternal__/cat/x0/_ID_/5c4oa2y-6zewp7-fb3ro8v8-1-fb3ro8v8-2)
| 17:55:46,578 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?)
(/__JBossInternal__/cat/x0/_ID_/5c4oa2y-6zewp7-fb3ro8v8-1-fb3ro8v8-2)
| 17:55:46,672 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/__JBossInternal__/cat/x0/_ID_)
| 17:55:46,672 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?)
(/__JBossInternal__/cat/x0/_ID_)
| 17:55:46,735 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/__JBossInternal__/cat/x0)
| 17:55:46,735 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?)
(/__JBossInternal__/cat/x0)
| 17:55:46,750 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/__JBossInternal__/cat)
| 17:55:46,750 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?)
(/__JBossInternal__/cat)
| 17:55:46,750 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/__JBossInternal__)
| 17:55:46,766 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?)
(/__JBossInternal__)
| 17:55:46,782 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/)
| 17:55:46,782 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?) (/)
| 17:55:46,797 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=?
(/__JBossInternal__/cat/x0/_ID_/5c4oa2y-6zewp7-fb3ro8v8-1-fb3ro8v8-2)
| 17:55:46,813 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=?
(/__JBossInternal__/cat/x0/_ID_/5c4oa2y-6zewp7-fb3ro8v8-1-fb3ro8v8-2)
| 17:55:46,829 DEBUG [JDBCCacheLoader] executing sql: update
ALLERGAN04.jbosscache_test set node=? where fqn=?
| 17:55:46,844 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x0)
| 17:55:46,860 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x0)
| 17:55:46,860 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?) (/cat/x0)
| 17:55:46,875 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat)
| 17:55:46,875 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?) (/cat)
| 17:55:46,891 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/)
| 17:55:46,907 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x1)
| 17:55:46,907 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x1)
| 17:55:46,907 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x1)
| 17:55:46,922 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x1)
| 17:55:46,922 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x1)
| 17:55:46,938 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x1)
| 17:55:46,938 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x1)
| 17:55:46,954 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x1)
| 17:55:46,954 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=?
(/__JBossInternal__/cat/x1/_ID_/5c4oa2y-6zewp7-fb3ro8v8-1-fb3ro96y-3)
| 17:55:46,969 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?)
(/__JBossInternal__/cat/x1/_ID_/5c4oa2y-6zewp7-fb3ro8v8-1-fb3ro96y-3)
| 17:55:46,985 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/__JBossInternal__/cat/x1/_ID_)
| 17:55:46,985 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?)
(/__JBossInternal__/cat/x1/_ID_)
| 17:55:46,985 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/__JBossInternal__/cat/x1)
| 17:55:47,000 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?)
(/__JBossInternal__/cat/x1)
| 17:55:47,000 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/__JBossInternal__/cat)
| 17:55:47,016 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=?
(/__JBossInternal__/cat/x1/_ID_/5c4oa2y-6zewp7-fb3ro8v8-1-fb3ro96y-3)
| 17:55:47,016 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=?
(/__JBossInternal__/cat/x1/_ID_/5c4oa2y-6zewp7-fb3ro8v8-1-fb3ro96y-3)
| 17:55:47,032 DEBUG [JDBCCacheLoader] executing sql: update
ALLERGAN04.jbosscache_test set node=? where fqn=?
| 17:55:47,047 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x1)
| 17:55:47,047 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat/x1)
| 17:55:47,063 DEBUG [JDBCCacheLoader] executing sql: insert into
ALLERGAN04.jbosscache_test (fqn, node, parent) values (?, ?, ?) (/cat/x1)
| 17:55:47,063 DEBUG [JDBCCacheLoader] executing sql: select node from
ALLERGAN04.jbosscache_test where fqn=? (/cat)
|
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4117383#4117383
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4117383
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
