Handling numerous rows from SQL query

Thread view:

CalAmity! - 15 Feb 2006 12:45 GMT

Scenario:
=========

[Web Brower]-------(data)------>[Apache Tomcat]----(query)--->[mySQL]
[Web Brower]---(some rows)----->[Apache Tomcat]<---(result)---[mySQL]

* Web Server hosts servlets and JSP.

* Web browser connects to Web Server
fetches query parametrs from the
user.

* Once parameters are submitted,
Data is sent to WebServer.

* Webserver runs servlets write an
appropriate query and fetch data
from mySQL.

* Result is displayed on user's browser.

Question:
======
The table I query is a Downloads Log.
So for some queries a very large amount
of data may be returned (say about 800-
1000 rows). I need to display this data
systematically 50 records at a time in
the web browser.
If anyone out there a solution to this
problem then please reply back.

Thanks in advance :)

Reply to this Message

Oliver Wong - 16 Feb 2006 21:05 GMT

> Scenario:
> =========
[quoted text clipped - 29 lines]
>
> Thanks in advance :)

Presumably you have some JSP somewhere between "Web Browser" and "mySQL"
that takes the rows and translates it to HTML. The web browsers can't
directly work with "rows"; they work with HTML.

So modify your JSP until you get the desired behaviour.

- Oliver

Reply to this Message

Big Jim - 16 Feb 2006 22:36 GMT

> Scenario:
> =========
[quoted text clipped - 29 lines]
>
> Thanks in advance :)

That's really not a huge number of rows, unless they contain some very large
fields. Return all your data in 1 structure (an appropriate list or map) to
minimise trips and use your JSP to display the required number of rows using
an index to select the rows and give your users links to the "pages" of data
on each jsp page.

Reply to this Message

Handling numerous rows from SQL query

Free Magazines