ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <lmead...@apache.org>
Subject Re: Cache entire table for use in an application
Date Wed, 23 Nov 2005 16:35:00 GMT
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?


On 11/23/05, ooper <maillist@roomity.com> 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.

View raw message