I'd like to know what is the best way to deal with large amount of data. I've some reports with complex SQL queries (lot of joins) and which return many lines, and I want my reports to be fast...
Should I use a sqlDataAdapter? a DataSet (and put it in cache or session?)? a business object?
Do you have some feedback to optimize reports?
Thanks in advance
Should I use a sqlDataAdapter? a DataSet (and put it in cache or session?)? a business object?
Do you have some feedback to optimize reports?
Thanks in advance
1 Answer, 1 is accepted
0
Hello jc mag,
Performance optimizations depend a lot on your project requirements and the final result which you want to achieve. For example, if the data from the query is static or is the same for different reports then it could be loaded into a DataSet object and then stored in the asp.net Session for future reference.
On the other side, if the query should be run every time to retrieve the new data then it will be better if you optimize the SQL Server's performance. It is not an easy task and there are different resources which explain how to do this. For example you can take a look at: http://www.sql-server-performance.com/.
As it concerns the performance of the reports, it depends on the amount of data, the complexity of the report definition and the used functionality such as grouping, sorting and filtering. In other words, by making more simple reports you will increase their processing speed.
Hope this helps.
Greetings,
Chavdar
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Performance optimizations depend a lot on your project requirements and the final result which you want to achieve. For example, if the data from the query is static or is the same for different reports then it could be loaded into a DataSet object and then stored in the asp.net Session for future reference.
On the other side, if the query should be run every time to retrieve the new data then it will be better if you optimize the SQL Server's performance. It is not an easy task and there are different resources which explain how to do this. For example you can take a look at: http://www.sql-server-performance.com/.
As it concerns the performance of the reports, it depends on the amount of data, the complexity of the report definition and the used functionality such as grouping, sorting and filtering. In other words, by making more simple reports you will increase their processing speed.
Hope this helps.
Greetings,
Chavdar
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center