Our environment
The stored procs for INS/DEL/UPD/FET are re-created for all entities used in our application.
Our problem:
- we see following statements when tracing our application.
create procedure dbo.[log_buffer_INS] and others
Our question
One special remark
+3Hi Geert
As far as I understand, Uniface creates procedures at most once when a connection is opened.
Does this creation occur multiple times within a session, or just once?
Ingo
Sorry, i do not have the complete log of the session. We received a screen shot from a customer.
So i am not sure. But why would uniface need to RE-create these procedures? They exist.
+3I asked my (“trusted” :-) AI, and it gave me this helpful illustration explaining "When a procedure is generated"
Nice flowchart, but ??
It seems to me that this step:
does not respect the ENTITIES section in the ASN-file, can someone confirm? or does this check & create has no influence on the performance?
+3Sorry Geert.
This is an AI-generated image. I can’t say for sure if everything in it is accurate, and I also doubt that the AI really knows all the facts. 😀
You’d have to ask UnifAce how it actually works in the end.
The only important thing for your original question is that the procedure is created only once per session. And that really doesn’t take much time.
Ingo
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
