>> I do not think even Client/Server could do this nicely. Have you ever seen anyone else put out an application in any design that has 2000 rows? <<
In a word, Yes. We had a client - system went live over 2 years ago using IIS on an Intranet as it happens. Client had > 600 branches UK wide, with >= 10 clients per branch (and in some cases many more than this) and wanted to see - on one page top (usually) 20 clients per branch with various metrics per client. No, they didn't want paging. No, they didn't want a smaller list (on this page). Yes - they wanted to see all records and then drill-down on the ones that interested them in a new browser window. We had to find a way to giving the customer what they had asked for or tell them it was not _technically_ feasible. The browser was known: IE5.5; it was always only ever accessed from a 100MBit LAN; the users were using powerful workstations. We used hints on the query to return top rows quickly - the metrics were calculated on data loading into the database - with incremental fetching and used fixed-width table to allow progresive fetching. Problem solved .. page was starting to render after about 3-4s and took about 40s to render fully - they could start viewing the data as soon as it started loading. Result: happy customer. >> What JDBC driver lets you stream data over, before the resultset/rowset has finished retreving? Or is the data fast, just the "rendering" is slow? << I don't know if JDBC can do incremental fetching - even so retrieving 1,600 rows should not take that long if the query is sensibly written and has useful indexes available. H. -----Original Message----- From: news [mailto:news@;main.gmane.org]On Behalf Of V. Cekvenich Sent: 02 November 2002 14:37 To: [EMAIL PROTECTED] Subject: Re: WebLogic/Struts/JSP performance woes... Are you saying you could write a servlet that could stream out javascript? Interesting. Else search for the display tag on google. What JDBC driver lets you stream data over, before the resultset/rowset has finished retreving? Or is the data fast, just the "rendering" is slow? Like Craig says, you should use busines domain knowledge to improve the users experience, so they could drill down somehow. I do not think even Client/Server could do this nicely. Have you ever seen anyone else put out an application in any design that has 2000 rows? V Davide Bruzzone wrote: > Lots of very ugly scriptlet code... :-) > > -----Original Message----- > From: V. Cekvenich [mailto:vicc@;users.sourceforge.net] > Sent: Friday, November 01, 2002 2:32 PM > To: [EMAIL PROTECTED] > Subject: Re: WebLogic/Struts/JSP performance woes... > > > How would you solve this w/o Struts? > .V > > Davide Bruzzone wrote: > >>Greetings all... >> >>I'd like to try to find out if anyone else out there is using WebLogic >>(We're using version 6.1 SP2) with Struts and/or just JSPs that might have >>some performance tips that they might be able to share... > > > <Snip> -- To unsubscribe, e-mail: <mailto:struts-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:struts-user-help@;jakarta.apache.org> -- To unsubscribe, e-mail: <mailto:struts-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:struts-user-help@;jakarta.apache.org>
