Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Most performant way to code client script.

Re: Most performant way to code client script.

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 17 Jul 2005 05:26:04 -0700
Message-ID: <1121603172.138789@yasure>


Christian Tischler wrote:
> Hi,
> I need to code some tool to get data from an Oracle database. The data
> will then be processed with some mathematical algorithms and then
> analyzed. As this is my first time using a database for something other
> than mere data storage I have some questions. If this is not the right
> list for my questions I apologize.
> 1) I it possible to run mathematic functions (statistical analysis and
> stuff like that) directly on the oracle DB?
> 2) What is the most performant DLL/lib/etc. to access the DB. We plan to
> implement the algorithms in C or C#.
>
> I would be very thankful if you could post an answer, links and/or books.
>
> thanks in advance
>
> Christian Tischler

Follow Mortiz's advice or look at whether the functionality you need is already in the database; for example analytic functions. You can complile PL/SQL into C inside of Oracle using native compilation. To find out how search for "Native Compilation" at http://otn.oracle.com.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Jul 17 2005 - 07:26:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US