Start Building Professional
Web Apps Today

1,00,000 records in dhtmlx grid using jsp

Hi to All,

My requirement is to retrieve the 1,00,000 records from the database and show in the dhtmlxgrid. but its giving the error java heapspace error. I am able to retrieve and keep the data as xml format in server side and loading as(load(data.xml) in jsp for 5,000 records only. but, how to get 1,00,000 records in jsp. i am getting and heap space problem.how to rectify this error.

please help me out.

Thanks in Advance,

Grid supports dynamic loading mode, in which grid will load only data necessary for current view , not the whole dataset. With such approach you can show huge datasets in dhtmlxgrid ( only small part of it will be really processed and downloaded to client side, so it must not cause problems with memory ) 

There are two approaches
live scrolling
http://dhtmlx.com/docs/products/dhtmlxGrid/samples/loading_big_datasets/50000.html
paging
http://dhtmlx.com/docs/products/dhtmlxGrid/samples/loading_big_datasets/50000_paging.html

Step by step guide, for server side code implementation can be checked at 
http://dhtmlx.com/docs/products/dhtmlxGrid/doc/step-by-step/ch_biggrid.html#grid_sbs_biggrid