• Post Reply Bookmark Topic Watch Topic
  • New Topic

is this possible...  RSS feed

 
Bill Brasskey
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a page where I'm pulling counts from a database for 6 different application types for each month of a particular year. the user selects a year from a drop-down box on page index.jsp. the page that shows the full table of all app types for each month of the year is index1. index1 doesnt come up for the user until all queries on the database are made, so it takes a bit of time...(i'm going thru a nested for loop, 12 times for each app type so 12*6 = 72 queries)i'm wondering if it's possible for me to go ahead and show the user the empty table on index1, and have it "populate" with the data as each query is completed.....basically, I guess I'm asking how I can show my static html stuff before the dynamic stuff.
sorry for the wordy question.

[ June 14, 2004: Message edited by: Bill Brasskey ]
[ June 14, 2004: Message edited by: Bill Brasskey ]
 
Alex Kravets
Ranch Hand
Posts: 476
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you might want to look into portlets. I've read a little about them and it seems like an interesting concept.
portlets
 
Nathan Pruett
Bartender
Posts: 4121
IntelliJ IDE Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It sounds more like the problem is that all those database requests are taking a long time. Structure your queries so that you don't need so many of them, and, if possible, try to cache any results that you know aren't going to change...
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!