Re: How do oracle programmers send batches of SQL from inside a program?
From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: Sat, 20 Mar 2010 18:26:37 -0400
Message-ID: <uzl22fx42.fsf_at_www.yahoo.com>
Thomas Gagne <TandGandGAGNE_at_gmail.com> writes:
> Performance. Do as much with a single trip to the database as
> possible to avoid going back and forth between client and server.
> Reduces network traffic.
Date: Sat, 20 Mar 2010 18:26:37 -0400
Message-ID: <uzl22fx42.fsf_at_www.yahoo.com>
Thomas Gagne <TandGandGAGNE_at_gmail.com> writes:
> John Hurley wrote:
>> <snip> >> >> Multiple sql statements in a batch? Why would you want to do that in >> oracle? >>
> Performance. Do as much with a single trip to the database as
> possible to avoid going back and forth between client and server.
> Reduces network traffic.
I would test this theory. In your OP, you said you were sending multiple select statements. I'd prove out that you are actually saving anything when you send multiple statements at once. Each statement would be returning a resultset. Where is the savings on the way out?
Then, once you see you aren't saving anytime, you can then have your client program execute a SQL statement exactly when it needs to.
-- Galen Boyer --- news://freenews.netfront.net/ - complaints: news_at_netfront.net ---Received on Sat Mar 20 2010 - 17:26:37 CDT