Does the datasource type effect load on demand performance

2 posts, 0 answers
  1. Water
    Water avatar
    13 posts
    Member since:
    Jan 2012

    Posted 18 Nov 2013 Link to this post

    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?
  2. Boyan Dimitrov
    Boyan Dimitrov avatar
    2062 posts

    Posted 21 Nov 2013 Link to this post


    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.

    Boyan Dimitrov
    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.
Back to Top