Hello,
We have to deal with a large amount of data from an Nhibernate queryOver (about 40.000 to 1.000.000 rows).
We need to show this data as a pivot grid restitution in our web app, and apparently, that kind of component would suits our needs.
As we have a lot of data :
- Would it be better to use Server-side pivot grid instead of KendoUI component ?
- Is it possible to do a dynamic skip/take with an Nhibernate query to avoid all data in memory by getting grid current settings like filter, order, paging ?
- If this is not possible with Nhibernate, would it be with a simple SQL query ?
Regards,
Maxime LEMARE.
We have to deal with a large amount of data from an Nhibernate queryOver (about 40.000 to 1.000.000 rows).
We need to show this data as a pivot grid restitution in our web app, and apparently, that kind of component would suits our needs.
As we have a lot of data :
- Would it be better to use Server-side pivot grid instead of KendoUI component ?
- Is it possible to do a dynamic skip/take with an Nhibernate query to avoid all data in memory by getting grid current settings like filter, order, paging ?
- If this is not possible with Nhibernate, would it be with a simple SQL query ?
Regards,
Maxime LEMARE.
4 Answers, 1 is accepted
0
Hello ,
Could you please elaborate a bit more on your scenario? What do you try to achieve – a grid which looks like a pivot table where database columns are presented as rows (reverse order - vertical grid) or pure pivot table where the control generates a report based on the database data?
In the first scenario you can use RadGrid controls as is described in the help topic above. Also you can use custom paging in order to execute operations on the database server.
If you try to achieve the second scenario– pure pivot table you need to use ASP.NET RadPivotGrid component. The Kendo PivotGrid does not support paging or filtering when it is bound to source different than a cube.
Looking forward for your reply.
Regards,
Radoslav
Telerik
Could you please elaborate a bit more on your scenario? What do you try to achieve – a grid which looks like a pivot table where database columns are presented as rows (reverse order - vertical grid) or pure pivot table where the control generates a report based on the database data?
In the first scenario you can use RadGrid controls as is described in the help topic above. Also you can use custom paging in order to execute operations on the database server.
If you try to achieve the second scenario– pure pivot table you need to use ASP.NET RadPivotGrid component. The Kendo PivotGrid does not support paging or filtering when it is bound to source different than a cube.
Looking forward for your reply.
Regards,
Radoslav
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
Au
Top achievements
Rank 1
Rank 1
answered on 19 Apr 2015, 02:25 PM
I need to display a grid which looks like a pivot table with the data returned from the server in JSON format (it seems the first scenario you mentioned above). How can I archive that? I don't use ASP.NET so cannot use RadGrid controls
0
Hello ,
You can try returning the json manually by calling your service and then transform in to the client or creating a new one based on the received which has rows as a columns. After that you can pass it as a datasoure of the kendo’s grid. Please give it try and let me know if it helps you.
Additionally please note that this thread is for RadGrid/UI for ASP.NET AJAX and to get opinion of the kendo experts you need to post your question in the kendoui forums or submit a ticket with kendo grid as a product.
I hope this helps.
Regards,
Radoslav
Telerik
You can try returning the json manually by calling your service and then transform in to the client or creating a new one based on the received which has rows as a columns. After that you can pass it as a datasoure of the kendo’s grid. Please give it try and let me know if it helps you.
Additionally please note that this thread is for RadGrid/UI for ASP.NET AJAX and to get opinion of the kendo experts you need to post your question in the kendoui forums or submit a ticket with kendo grid as a product.
I hope this helps.
Regards,
Radoslav
Telerik
See What's Next in App Development. Register for TelerikNEXT.
0
Au
Top achievements
Rank 1
Rank 1
answered on 22 Apr 2015, 07:39 AM
Hi Rado,
Right after posting my previous question, I recognized that I should ask on Kendo UI forum instead of here but I cannot find a way to delete. I will try implementing as your suggestion. Thanks for your reply.