DevForce Community Forum : Running Stored procedure http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Running Stored procedure Tue, 12 May 2026 22:59:25 -700 Thu, 21 Mar 2013 09:33:27 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4055 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Running Stored procedure : Peter, Is this the very first... http://www.ideablade.com/forum/forum_posts.asp?TID=4055&PID=16082#16082 Author: sbelini
Subject: 4055
Posted: 21-Mar-2013 at 9:33am

Peter,

Is this the very first operation performed?

Do subsequent calls to the same stored procedure take as long as the first execution?

If the call to the stored procedure is the first operation, the issue could be the startup time.
You can take a look at the server debug log to determine if that's the case.
If the startup time is indeed the issue, you can reduce startup time by controlling discovery. You will find more details at http://drc.ideablade.com/xwiki/bin/view/Documentation/discovery.


You could also time the execution in the QueryInterceptor. This would help compare the execution time in the server (i.e. BOS) vs. in the client and determine if the data traffic would actually be the culprit. More details at http://drc.ideablade.com/xwiki/bin/view/Documentation/query-server-lifecycle-events.


Edited by sbelini - 21-Mar-2013 at 9:34am]]> Thu, 21 Mar 2013 09:33:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4055&PID=16082#16082 Running Stored procedure : Thanks,Stored procedure output... http://www.ideablade.com/forum/forum_posts.asp?TID=4055&PID=16069#16069 Author: PeterProva
Subject: 4055
Posted: 20-Mar-2013 at 6:30am

Thanks,
Stored procedure output is just a Number you can asume the getting the Max Number.
]]> Wed, 20 Mar 2013 06:30:41 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4055&PID=16069#16069 Running Stored procedure : Peter, What does the stored procedure... http://www.ideablade.com/forum/forum_posts.asp?TID=4055&PID=16059#16059 Author: sbelini
Subject: 4055
Posted: 19-Mar-2013 at 2:20pm

Peter,

What does the stored procedure do? Is it retrieving records? How many?

Additional time is taken to instantiate records into objects. (i.e. entities)
Also, remember that these entities go across the wire to reach the client.
]]> Tue, 19 Mar 2013 14:20:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4055&PID=16059#16059 Running Stored procedure : Hi guys,I am using StoredProcedureQuery... http://www.ideablade.com/forum/forum_posts.asp?TID=4055&PID=16058#16058 Author: PeterProva
Subject: 4055
Posted: 19-Mar-2013 at 12:51pm

Hi guys,
I am using StoredProcedureQuery in Devforce 6.1.7  Silverlight 5 and it takes 15 to 17 seconds,however same Stored procedure on the server is not even 1 second.Any idea?
thx
]]> Tue, 19 Mar 2013 12:51:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4055&PID=16058#16058