at this time we are not using CMR and I have a small question. whe have this three tables:
tree structure:
CREATE TABLE "category_tree" ( "category_tree_id" BIGINT NOT NULL, -- (PK) "parent_id" BIGINT, "mandant_id" BIGINT NOT NULL, -- (FK) "position" SMALLINT NOT NULL, "path" VARCHAR (255), "description" VARCHAR (255) NOT NULL, );
translations:
CREATE TABLE "category_translated" ( "category_translated_id" BIGINT NOT NULL, -- (PK) "language_id" SMALLINT NOT NULL, -- (FK) "entry" VARCHAR (100) NOT NULL, );
context:
CREATE TABLE "category_context" ( "category_context_id" BIGINT NOT NULL, -- (PK) "category_tree_id" BIGINT NOT NULL, -- (FK) "category_translated_id" BIGINT NOT NULL, -- (FK) );
now if we want a tree structure for given mandant_id than we do:
category_treeLocalHome.findByMandantId(mandant_id) --> cached by JBoss
for each category_tree_id do:
category_contextLocalHome.findByCategoryTreeId(category_tree_id) --> on each call as db, slow by much entries in category tree table
for each category_context_id do
category_translatedLocalHome.findByPrimaryKey(category_translated_id) --> cached by JBoss
would it be better to use CMR for better performance.
we thinking about own caching implementation for the context informations.
Regards, Rafal
------------------------------------------------------- This SF.net email is sponsored by: Etnus, makers of TotalView, The best thread debugger on the planet. Designed with thread debugging features you've never dreamed of, try TotalView 6 free at www.etnus.com. _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
