Re: Embedded SQL vs Stored Procedures

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 8 Sep 2004 05:56:24 -0400
Message-ID: <muqdnbBgTajWSqPcRVn-pQ@comcast.com>

...
"Gama Franco" <gama_franco_at_clix.pt> wrote in message news:chmgit$4hv$1_at_pegasus.fccn.pt...
| Hi,
|
| The tables are not dropped after creation. The point is that no DBMS
| provides temporal tables (tables based on the temporal extension to the
| relational model), so we need a system that provides them. This is the
| main issue here. Now, I'm afraid that a stored procedure that does all
| the actions needed to create such tables might be slower than doing them
| in procedures on OCCI (code those procedures in C++ rather than in PL/SQL)
|
| Best regards,
| Gama Franco

don't worry about stored procedures being slower -- only if you're doing intensive non-database calculations will you start to see advantages in the C++ performance, and even then, Oracle supports automatic native compilation of stored procedures

++ mcs Received on Wed Sep 08 2004 - 04:56:24 CDT