A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
multiple statements or in a stored proc
Joined: Oct 23, 2003
Feb 28, 2004 07:38:00
What is a better apporach to have in a scenario where i have 10 DML (ins/upd/del)to execute.
Whether to use 10 individual statements or have all of them in one stored proc
Joined: Feb 28, 2003
Feb 28, 2004 09:32:00
The solution depends on the architecture of your application. I prefer keeping it in the
(10 statements), but there are times where you'd use a procedure as well.
author & internet detective
Joined: May 26, 2003
Feb 28, 2004 16:45:00
You could use
to batch the 10 statements into one database trip. This would provide most of the advantages of a stored procedure while keeping all the code in java.
OCA 8 book
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: multiple statements or in a stored proc
Sorting Strings in Oracle
How to load a Java application to Oracle DB
SQL Server performace
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015