Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Subathra on Aug 12, 2009 03:12
open dhtmlx forum
TreeGrid loading process is very slow.

Hi,

I am trying to load the data in Treegrid with over a 4000 records at one go and it starts to hang the browser while it is rendering.

Shall we do something to increase the speed or make it perform better. I have used the smartRendering but its the same as.
Answer posted by dhxSupport on Aug 12, 2009 03:21
Answer posted by Subathra on Aug 12, 2009 03:40
Hi,

       I have generated a xml for this Treegrid and Parent item count is more than 2500 records. So i can't use the first solution and i tried the paging, Smart parsing, Smart Rendering, but its the same as.

Can u give me any other way to solve this issue?

Please help me.

Thanks & Regards,
    P.Subathra
Answer posted by dhxSupport on Aug 12, 2009 07:30

You can try to use paging extension. http://dhtmlx.com/docs/products/dhtmlxTreeGrid/samples/loading_big_datasets/treegrid_paging.html
In such case only those rows are rendered which should be displayed to the user.

Answer posted by Subathra on Nov 04, 2009 01:20
Hi,

       In initial stage, when loading or reading the xml is very slow. It is taking  around 2 1/2 mins. I have to reduce it. Please help me.

I have used SmartRendering, SmartXMLParsing and pagination, but these are all working after loading the xml. Please give me your suggestion

Thanks & Regards,
   P.Subathra



Answer posted by dhxSupport on Nov 04, 2009 03:00
I have used SmartRendering, SmartXMLParsing and pagination, but these are all working after loading the xml.
enableSmartRendering(true) method is incompatible with enableDistributedParsing and enablePaging methods. You should use only one of them. Please check if you have slow connection between client and server side. In such case there is no way to increase loading performance using DHTMLX components. 
Answer posted by Subathra on Nov 04, 2009 04:08
Hi,

      Please tell me which one is the best while loading 6000 records in single page (XML, HTML or JSON or PHP file with pagination)?

I have changed the configuration file (It is pointing my local db) in my professional edition. It is displayed very fast, but i tried to display it in my project, it is taking more times.

Please ensure it (which one is best while loading 6000 records).

Please help me. It is very urgent.


Thanks & Regards,
   P.Subathra
Answer posted by dhxSupport on Nov 04, 2009 06:42
The best way to increase loading performance in your case is to use dynamic loading from XML format. Please find example here http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/14_loading_big_datasets/01_50000.html and step-by-step tutorial here http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxgrid:toc_dhtmlxgrid_step_by_step
Answer posted by Subathra on Nov 04, 2009 21:00
Hi,

        Thank you so much. I tried it, i think pagination is not working. I have 4500 records but it is showing first 100 records and i have to display it in Tree grid format. Is it possible. Please give me your guidance. It is very urgent.

Thanks in advance.

Thanks & Regards,
    P.Subathra
Answer posted by Subathra on Nov 04, 2009 23:27
Hi,

        Thank you so much. I tried it, i think pagination is not working. I have 4500 records but it is showing first 100 records and i have to display it in Tree grid format. Is it possible. Please give me your guidance. It is very urgent.

Thanks in advance.

Thanks & Regards,
    P.Subathra
Answer posted by Subathra on Nov 05, 2009 00:16
Hi,

        Thank you so much. I tried it, i think pagination is not working. I have 4500 records but it is showing first 100 records and i have to display it in Tree grid format. Is it possible. Please give me your guidance. It is very urgent.

Thanks in advance.

Thanks & Regards,
    P.Subathra
Answer posted by Subathra on Nov 05, 2009 01:03
Hi,

        Thank you so much. I tried it, i think pagination is not working. I have 4500 records but it is showing first 100 records and i have to display it in Tree grid format. Is it possible. Please give me your guidance. It is very urgent.

Thanks in advance.

Thanks & Regards,
    P.Subathra
Answer posted by Alex (support) on Nov 05, 2009 01:41

Hello, 

did you try Smart Rendering functionality ? It allows to render rows by portions and solves the performance issue:

http://www.dhtmlx.com/docs/products/dhtmlxTreeGrid/samples/02_loading_big_datasets/03_treegrid_srnd.html

To enable this mode you need to include dhtmlxGrid/codebase/ext/dhtmlxgrid_srnd.js and call the grid.enableSmartRendering(true) method.