Efficient way to calculate value for mathematical function from db?

Asked By tharshanthonline 0 points N/A Posted on - 12/05/2012

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

• Status: Open
• Question Views: 642
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: dBase

Best Answer by May Jratr

Go To Solution

Answered By Alcaraz Jody 5 points N/A #162248

Efficient way to calculate value for mathematical function from db?

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/

 

About Alcaraz Jody

Questions
2

Answers
100

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 12/15/2012
• Question Category: dBase

Best Answer

Best Answer

Answered By May Jratr 0 points N/A #162249

Efficient way to calculate value for mathematical function from db?

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,

About May Jratr

Questions
2

Answers
100

Best Answers
31

• Vote Up 0 Vote Down

• Posted on - 12/18/2012
• Question Category: dBase