If the data is static (and it sounds like it is), why not just build the tree when your app starts, and work with it that way?
Larry On 11/23/05, ooper <[EMAIL PROTECTED]> wrote: > 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. >
