Re: Pro*C 2.2 too slow !

From: Mark McNulty <mmcnul_at_jpmorgan.com>
Date: 1997/02/07
Message-ID: <5dfv4c$q69$3_at_news.ny.jpmorgan.com>#1/1


In article 131_at_mail.prodv.de, bittner_at_prodv.de (Christian A. Bittner) writes:
> Hello Folks!
>
> I'm developing Pro*C 2.2 based applications within an UNIX/ORACLE
> 7.3-environment (SINIX Risc Machine).
> Unfortunately the Pro*C - precompiler is terrible slow when setting
> the "sqlcheck=full"-feature. In this case the precompiler connects to
> the database - and that leads to poor performance (~5min for an
> average complex precompiling). And time is money...
 [snip]
> Christian A. Bittner

[Quoted] Use stored procedures, which would allow you to change the SQL without re-compiling, or use some non-compiling tool, or run the PL/SQL on the database server.

Good luck,
Mark McNulty
Quadris Consultant
mmcnul_at_quadris.com

Note-these views are my own and not those of JP Morgan or JYACC. Received on Fri Feb 07 1997 - 00:00:00 CET

Original text of this message