File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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 Java (10 statements), but there are times where you'd use a procedure as well.
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
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
SQL Server performace
How to load a Java application to Oracle DB
Sorting Strings in Oracle
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014