Re: Access/Oracle Stored procedures?

From: <ps_at_netvigator.com>
Date: 1996/07/14
Message-ID: <4sb0u2$6t9_at_imsp003.netvigator.com>#1/1

> "Raul P. Murguia" <murguia_at_mail.utexas.edu> writes:
> I am designing a form in Access that allows the user to query
> a remote Oracle table. I build an SQL query from the text boxes
> that the user fills out. Unfortunately, the query is too slow
> right now.
>
> I am vaguely familiar with the concept of stored procedures. Could
> they help speed up the app?
>
> Are there any good books on how to call a procedure from Access
> & how to code it on the Oracle db?
>
> Any help would be appreciated.
>
> Thanks.
>

>>>>
Stored procedure do help when you have many SQL statement in a single transaction, because it reduces communication. Also, stored procedures are compiled and stored in the database. This helps a little bit in performance. But if you Access query are only simple SQL but you still find it too slow, I wonder whether you could have great performance gain by using stored procedure.

Nearly every PL/SQL book talked about stored procedure. Try Oracle's document: "PL/SQL Users's Guides and References", if you already get it. Then try O Reilly's "ORACLE PL/SQL programming".

P.S.

~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~ ~~~~~~~~~

 ~~ Life is always Hard ~~~~~~~~~ ~~~~~~ ~~~~~ ¥Í¬¡±q¤£»´ÃP ~~~~~~ ~~~~~~~

  ~~~ Love is never Smooth ~~ ~~~~~~~~~~~~~ ~~~~ ·R±¡§ó«D©Z³~ ~~~~~~~~~~~~~~
   ~~~~ Always Love hard and never Life smooth ~~~ °ß¦³¼ö¤Á¦a·R,Åý¥Í©R§óºëªö ~
    ~~~~~~~~ ~~~~~ ~~~ ~~~~~~~~~~~~~~~ ~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~~ 
~~~~~~~~
     ~~~~ ~~~~~~~~~~~~~~~~~~~~~ ~~ ~~~~~~~~~~~ ~~~~~~~~ ~~~~~~~ ~~~ P.S. ~~~~~
                                                      ~~~~ ~~~~~~~~~~ ~~~~~~

Received on Sun Jul 14 1996 - 00:00:00 CEST