My experience is that using commit option A or D and cmr speeds up these processes significantly once the caching kicks in. Rafal Kedziorski wrote:
> hi, > > 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 -- ************************************************************************** This message is intended for the named recipient only and is confidential and no other person can place any reliance upon it. The recipient acknowledges that transmissions made via the Internet can be corrupted and therefore Chase de Vere Financial Solutions plc does not give any warranty as to the quality or accuracy of any information contained in this message or assumes any liability for it or for its transmission, reception or storage. This footnote also confirms that this e-mail message has been swept for the presence of computer viruses. Chase de Vere Financial Solutions plc is authorised and regulated by the Financial Services Authority and is an independent financial adviser. ************************************************************************** ------------------------------------------------------- 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
