Hi!
You may try to use inserting of arrays instead of one record in PRO*.
It works much more faster.
Viatcheslav
- Original Message -----
From: Leng Kaing <leng.kaing_at_hancorp.com.au>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: 21 ÉÀÎÑ 2000 Ç. 09:34
Subject: Pro*C/Pro*Cobol vs PL/SQL Performance
> Dear all,
>
> Has anyone done any testing in this area? Any findings? We've done a
simple
> test here and found that the precompilers were much slower than PL/SQL.
The
> program just had a loop that fetches a row from a tiny table 20K times.
>
> The problem seems to be with the number of roundtrips the precompiler
> language needs to make to the database, whereas when calling a PL/SQL
> package there does not seem to be that overhead.
>
> So any papers/findings that you can refer me to? I've read the standard
> Oracle Pre*compiler tuning stuff so am looking for something more
technical
> to support or deny the theory. Any ideas on how long it takes to make the
> roundtrip?
>
> The bigger picture is that we are trying to decide whether to go Pro*Cobol
> or PL/SQL. So any white papers or external experience would be well
> appreciated.
>
> Thanks,
>
> > Leng.
> > -----------------
> > Leng Kaing
> > Tel: +61-3-9843-8440
> > Email: leng.kaing_at_hancorp.com.au
> >
> --
> Author: Leng Kaing
> INET: leng.kaing_at_hancorp.com.au
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jun 21 2000 - 00:35:06 CDT
