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?

Larry


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.
>

Mime
View raw message