Efficient way to calculate value for mathematical function from db?

Asked By 0 points N/A Posted on -
qa-featured

Css registry 2012

In. NET, another window or a web application,

To perform various mathematical functions such as sqrt, max, min, average, count with larger data sets. 

Using stored procedures or program logic with normal iteration. 

What is the best way to do it.?

SHARE
Best Answer by May Jratr
Answered By 5 points N/A #162248

Efficient way to calculate value for mathematical function from db?

qa-featured

To perform various mathematical functions such as sqrt, max, min, average, count with larger data sets with a perfect accuracy I recommend you to download Casio online Calculators I will give the link below, and if you are insisted on making your own software you do this with Mat lab program it will give you an easy and accurate way for making your program.  

This is the link for free scientific calculators.

http://www.casio-intl.com/asia/en/calc/

 

Best Answer
Best Answer
Answered By 0 points N/A #162249

Efficient way to calculate value for mathematical function from db?

qa-featured

Hello Tharshanthonline,

Hope that my message finds you well.

Of course you will use stored procedures for this purpose. Stored procedures are ordered series that used generally with SQL statements, this allow you to use all the functions that you want to use in the database (Max, Sum). These files will saved in a database not in separate files.

The advantage of this is to:

1. Less network usage/traffic and you will use small names not a long text.
2. Stored procedures are precompiled.
3. Provide you with a process for security.
4. Can be called anywhere in your code.

You can use two parameters with stored procedures:

1. Input to use them inside the database.
2. Output to retrieve the database value.

When using stored procedure take care of the following:

Direction, data type, the default value and the name.

For more details about it please see the following URL:

http://csharp-station.com/Tutorial/AdoDotNet/Lesson07

Hope this solution will help.

Kind regards,

Related Questions