Problem with LiveGrid

[arindamlala]

Hi,

I am facing a problem with LiveGrid. In my application, the data is being populated to livegrid from Servlet which supplies 50,000 rows of data, It is generally taking much time to load data for the first time. But when I am doing sorting on any column, it taking so much time that Internet Explorer is giving an alert saying: "Stop running the Script? A script on this page is causing Internet Explorer to run slowly. If it continues to run, your computer may become unresponsive."
This is a serious performance issue as I have to submit the code sample to client. I have attached all the codes. Please suggest any possible way to stop this alert? I also want to know how will I implement cache memory utility so that everytime when i run the application, data can be loaded from the cache memory.

Thanks
Arindam

[mike.art1]

You shouldn't be loading all 50K records at once. The datasource passing parameters startrow, endrow as part of the request and your servlet should just be returning that segment of data

[Przemeq]

Can you provide any example, how to pass startrow, endrow parameter from datasource to callback, please?

[fargo]

In your datasource, override the transformRequest like follows

    @Override
    protected Object transformRequest (DSRequest dsRequest)
    {
        if (dsRequest.getOperationType () == DSOperationType.FETCH)
        {
            JSOHelper.setAttribute (data, "_endRow", dsRequest.getEndRow ());
            JSOHelper.setAttribute (data, "_startRow", dsRequest
                    .getStartRow ());
        }

        return super.transformRequest(dsRequest);
    }

and in the servlet backing the datasource, you can get these parameters and handle them to provide the iterated result.

....
String startRow = request.getParameter ("_startRow");
String endRow = request.getParameter ("_endRow");
...
...
// Handle the resultset to iterate from startRow to endRow.
....

Hope it helps.

[arindamlala]

Thanks a lot for your help. It works.

[HeMan]

Hi, Can you please share the code that worked. It would be really very helpful.

[HeMan]

Also, looking at the code snippet fargo had written, how does the listgrid (livegrid) actually know that there are more rows to come. I mean, do I need to fire a fetch using a scrollhandler? Would it be possible to share a worked out example?

[mdrafi]

Can anyone pls share the code of the Live Grid with huge amount of data loaded.

Thanks

[nikkali]

Ok with 50K records.
But when i've only 2 records the listgrid don't filter when i use the native filter.
What's the problem?

In your datasource, override the transformRequest like follows

    @Override
    protected Object transformRequest (DSRequest dsRequest)
    {
        if (dsRequest.getOperationType () == DSOperationType.FETCH)
        {
            JSOHelper.setAttribute (data, "_endRow", dsRequest.getEndRow ());
            JSOHelper.setAttribute (data, "_startRow", dsRequest
                    .getStartRow ());
        }

        return super.transformRequest(dsRequest);
    }

and in the servlet backing the datasource, you can get these parameters and handle them to provide the iterated result.

....
String startRow = request.getParameter ("_startRow");
String endRow = request.getParameter ("_endRow");
...
...
// Handle the resultset to iterate from startRow to endRow.
....

Hope it helps.

[mdrafi]

Hi Nikkali,

Check for setFilterOnKeypress(true) on the grid and setCanFilter(true) to the element/column on DS.

[nikkali]

Hi mdrafi,
this properties are set in true, but don't make filter.

Hi Nikkali,

Check for setFilterOnKeypress(true) on the grid and setCanFilter(true) to the element/column on DS.

[nikkali]

I've resolved.
I muss inserted the fetchdata method on listgrid and rewrite the DSCallback.

Hi mdrafi,
this properties are set in true, but don't make filter.