DevForce Community Forum : Calculations on server http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Calculations on server Mon, 13 Apr 2026 15:39:50 -700 Thu, 01 Dec 2011 12:48:51 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3119 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Calculations on server : Hi Mark;Our suggestion is to use... http://www.ideablade.com/forum/forum_posts.asp?TID=3119&PID=12147#12147 Author: DenisK
Subject: 3119
Posted: 01-Dec-2011 at 12:48pm

Hi Mark;

Our suggestion is to use a hybrid of the 2. 

A server method, and calling stored proc within the server method to do db intensive processes if necessary.
]]> Thu, 01 Dec 2011 12:48:51 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3119&PID=12147#12147 Calculations on server : In our app we have to do a few... http://www.ideablade.com/forum/forum_posts.asp?TID=3119&PID=12145#12145 Author: smi-mark
Subject: 3119
Posted: 30-Nov-2011 at 8:48pm

In our app we have to do a few balance calculations, involving dates, so we don't want to bring back all this data to the client and calculate it there.

On one of our search screens we would like to show the current balance for the customer, and filter by customers with a balance. When you are dealing with many results, bringing back all the data needed to calculate a balance is ridiculous.

One option is a stored procedure, but then we lose the flexibility of having dynamic filters and ordering on queries (Well this is still possible but more work)

Another option is a server method, and have the server bring back all the data, calculate it, and then return a projection to the client.

What do you recommend? The stored proc would obviously be the fastest way, but you lose flexibility.
]]> Wed, 30 Nov 2011 20:48:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3119&PID=12145#12145