Annu Singh <[EMAIL PROTECTED]> wrote:
__________
>Hi All,
> We have an application that we are planning to "Browser enable".
>
> This application generates huge reports with thousands of records.
> Q1) Which is the best way to generate these reports (on the browser)?
If you want my advice-
Don't.
When you web-enable an application
you need to review the user requirements.
In my experience no one wants to
plough through huge pages in a
browser.
For these reports you might concider these options:
1) add better search tools so
that users can interaltively find the
results they want- make sure you
let them open multiple queries
so they can compare.
2) write an applet that allows
the user to browse the data - in
a graphical form if appropriate.
3) allow the user to download the data into a local application
(excell). If you do this, try to use
a portable file format (.csv) without
macros.
> Q2) We also need to do field level verification as and when the user
>is inputting data (even before the user submits the form. For example the
>verification is to be done when there is a change of focus). For
>verification we have to go back to the database (The input data is
>validated against some existing records in the database).
>In the prototype we had build we had used Java applets and in it we were
>calling ASP scripts to access the Database but it is extremly slow. Is
>there any other way/architecture to increase the speed (using Servlets, etc
>....).
Careful design will speed it up a bit,
but you will always be limited by
the round-trip time to the database.
Again, I think you need to review your requirements. To get decent
response you would have to have
a lot of data cached in the browser,
which generally isn't a good plan.
T.
URL http://www.westhawk.co.uk/
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
