Discussion Locked

C Embedded SQL vs Store Procedures

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to if someone can help in answering my question, which of the following programming methods has the application highest performance:
a. C & embedded SQL
b. C calling store procedures
The development environment is TUXEDO 7.1, which will provide the services, applications and the Database is ORACLE 8.1.7.3.1.5

3 replies

by glen_mcleod

Stored procedures will always be faster that embedded SQL statements. SQL statements have to go through 5 steps in order to be executed, and embedded statements always go through all 5.

Parsing
Validation
Optimization
Compilation
Execution
Stored procedures have the first 4 done at creation, so it's only the last step that needs to be done at run time.

Their execution plans are also stored in the cache once they've been executed once, so there's no need to fetch them from disk repeatedly.

Glen

by avtheos

Your answer could be more specific on BEA Tuxedo but if I'm not wrong you don't have no background on BEA Tuxedo.

This discussion is closed to new replies.