Hi All,

Im working on generating reports from the db2 table. db2 table has around 2 million records, and after applying some filter conditons the report will get around 1.5 lakh records. Im using webviewer=on command.
1) If webviewer=on then it will fetch all the records to the webserver. even if its off it is fetching all the records . I think the user gets all the records at the same time for both the conditions. Then what is the advantage in using webviewer=on other than search,next,previos buttons features. If the desktop has the sufficient memory then which way is the best for displaying report. can anybody give explonation interms of space and time constaints both in server and client side.
2) If we set webviewer=on then it will fetch all the records to the webserver. Here the question is a) where it gets stored and in which form. b) Which memory has to be increased on the server side, Application folder memory or RAM or anyother memory.
3) How to handle this much of records in excel 4) What is the best way of showing these records in pdf format.


Regards,
CDPrasad

The webviewer controls the data from the web server to the user, not between the data source and the web server.

With webviewer=on, the user can view the first page, and other pages, of the report quicker utilising the on-demand paging facility, as not all data needs to be downloaded to start viewing. You can see the difference in performance by viewing the first page, then the last page, don't think that now all the data is back on the user machine. For this press the all pages button and see what happens then.

The output data from the DB2 will reside, normally, in the agent temporary directory first, unless pointed somewhere else. This data will (normally) disappear after the request for the user has completed. Then the data resides in the windows temp directory on the server for the odp and in the internet temp file folder on the user machine, I believe.

Excel 97 to 2003 can open a file with 64k records; a macro can be built to open a larger file into multiple worksheets. Later versions can handle 1 million (approx) rows so can handle your 150,000 rows straight off.

Not sure how PDF will handle this amount of data, it should handle this, though slowly.

This is a lot of data to be passing around the web and will stress many components on the server and the user machine.

Can any body post the code how to write a macro for exl2k to open a larger file into multiple worksheets.

Thanks,
cdprasad

Try this link as a starting point.