Slow slow Pro*C compilation with sqlcheck=semantic
From: Thomas <tjp_at_mail.sonofon.dk>
Date: 2 Sep 2003 01:26:43 -0700
Message-ID: <3d3ddabe.0309020026.41338dd6_at_posting.google.com>
Date: 2 Sep 2003 01:26:43 -0700
Message-ID: <3d3ddabe.0309020026.41338dd6_at_posting.google.com>
I am trying to compile a Pro*C program. I am using embedded SQLPlus so I am forced to set SQLCHECK=SEMANTIC which is OK.
Now, I have 2 databases: one is a development and the other is production. They should be the same. Tables, indexes etc. are the same in the two databases.
If I compile against the production the precompile is very fast. But if I point the Pro*C to the development database the precompilation becomes extremely slow. It takes several hours - but it eventually gets through!?!
Does anyone have any idea what I should look for?
Any help appreciated
/Thomas Received on Tue Sep 02 2003 - 10:26:43 CEST