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?
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
0
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
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.