On Feb 1, 2004, at 9:22 PM, Nikhil Sidhaye wrote:

> Hi Andy ,
>
>     Can you reproduce the same results with hardcoded ArrayList
> objects (without connecting database)?

Hey there.  I found that the problem was actually do to reloading the
bean with the data from the database each time I was loading a page. 
Each time I wanted to go through the data I was hitting the database,
which was causing the delay.  The way I worked around it is that in my
action class I am checking what the query string is that I am passing
in.  If the query string is null, then that means that I am probably
not doing any of the fancy stuff with displaytag, such as sorting,
going through the pages, etc.  So, if that query string is null, that
is when I am hitting the database, loading the data into a bean, and
shleping that into the session scope.  If there is a query string, I
just stick with what I already have in the bean.

One of the other members of this mailing list (Zoran Avtarovski)
suggested that I look into the use of iBatis, which I got more into
today.  I am going to figure out how I can get all that to work, which
Zoran suggested would probably take care of the problem in addition to
making it a more efficient solution.

Anyway, to answer your question, I don't have the same results when I
work without hitting the database.  It's only when I hit the database
multiple times that I get the delay, which is due to our database
server being overloaded with so much junk.  I wish (the company I work
for) would spend some money and get us some new servers that can handle
the load!  They did just get us dualies with a gig of memory, which was
nice though.

Thanks for responding!


Andy


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to