This is a migrated thread and some comments may be shown as answers.
Does the datasource type effect load on demand performance
1 Answer 5 Views
This is a migrated thread and some comments may be shown as answers.
Water
Top achievements
Rank 1
Water asked on 18 Nov 2013, 12:57 PM
Generally a stored procedure will be more efficient than raw sql when querying a sql server database. I'm just wondering does it effect the load on demand feature of RadComboBox in any way?

As I don't understand the method it's using to pull down partial results from the database, I don't know which is more efficient. Am I better off setting up a SqlDataSource with a select statement in it or just point it at a stored procedure - does it make any difference?

1 Answer, 1 is accepted

Sort by
0
Boyan Dimitrov
Telerik team
answered on 21 Nov 2013, 01:50 PM
Hello,

In general stored procedures are a batch of SQL statements that can be executed in a couple of ways. So the stored procedure is actually a set of SQL queries. I believe that in performance aspect there will be no significant difference but the stored procedures gives lots of different benefits. I would like to encourage you to review the following help article that explains some good aspects of using the stored procedures.

Regards,
Boyan Dimitrov
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Asked by
Water
Top achievements
Rank 1
Answers by
Boyan Dimitrov
Telerik team
Share this question
or