Hi,all:
when loading a table with more than 1 million items will get erro from the browser ..
It is seems that the webfoucs display the table when the all data loaded .
Why not load the data only 1 page or 5 page ?
And load the another data only if turn the page ?
Waiting for your reply!

This message has been edited. Last edited by: Kerry,

You can set WEEBWIEVER=ON. I think WF will still read all rows, but write it to a file and read from that file, one page at a time.

Håkan

Oh well, the browser has no notion of pages ...
and it is WEBviewer (one E in WEB) ...

Gerard, you're right, the browser has no concept of pages, but the way I've understood it, as soon as WF has received the no of rows which will fit the viewer which is determined by the actual resolution, those rows are sent to the browser. And, I know its WEBVIEWER (I obviously let my fingers slip a bit).

Håkan

quote:

Originally posted by Håkan:
You can set WEEBWIEVER=ON. I think WF will still read all rows, but write it to a file and read from that file, one page at a time.

Håkan

Thanks,but could you tell me how to set the WEBVIEVER=ON ?.


By the way ,even if set the WEBVIEVER=ON , as you say ,it will still read all rows and write it to a file.
But I think the step is the browser write the data to file only when it load all the data.
so the browser's Memory will overflow before write the data to file.??

I'm always curious when I see procedures to display a million rows; once displayed, what will be done with them?

quote:

how to set the WEBVIEVER=ON

You've got to be kidding, right?

Also with webviewer on all records are read fromt he data source, stored in a temp files omethere on the server's disk, and referenced whenever a new page is requested. The file will not be kept indefinitely, there's probably some timeout setting to control that.
Therwe's also a setting that controls how many lines are to be displayed in the webviewer at one time. And you can also specify the target - ie which window the webviewer is to be displayed in.
There's enough documentation to be found on this tool - just look for it in the right place(s).

I go with jimsters answer, not solvng your problem of the million rows
It is not a real option.

Try to create INFORMATION instead of dataload.
the next step might be that you print it!!
1000000/60=16000 pages of data
that is a tree!!!