Hi ooper,
There is a smart alternative to the use of
parent child relation and the resulting recursive queries;
The Nested Set Model.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
MEINDERT
HOVING
From: ooper
[mailto:[EMAIL PROTECTED]
Sent: 23 November 2005 06:30 PM
To: user-java@ibatis.apache.org
Subject: Re:Cache entire table for
use in an application
I have a recursive function that builds a tree menu from data in the
db. The recursive function executes
a sql query against the database for each node of the tree, so as the tree gets
larger, the time needed to
build it becomes larger. In an effort to enhance performance, I wanted to pull
data into memory, and
then execute recursive sql queries against memory.
Brian
Broadband interface (RIA) + mail box saftey =
http://iBatis_for_Java_Users_List.roomity.com
*Your* clubs, no sign up to read, ad supported; try broadband internet.
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.5/178 - Release Date: 22/11/2005
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.5/178 - Release Date: 22/11/2005
|
