Re: Becoming a FAQ: Executing multiple sql statements in a single network round trip

[Matthew T. Adams]

Yes, they are mostly queries.  Yes, I know I can
cache, as long as the data underneath doesn't change. 
These happen to be for reporting purposes, and the
nature of the reports require (so far) the creation of
a temporary table and a subsequent select from it.

It's not that I don't appreciate the suggestions, but,
please, can someone tell me if there is a way to batch
statements using MySQL via Connector/J?

--- Christopher Taylor <cstaylor@stripped> wrote:
> Are you mostly making queries?  Why not cache that
> information instead of
> going to the database everytime?
> 
> -Chris
> 
> ----- Original Message ----- 
> From: "Matthew T. Adams" <matthewadams@stripped>
> To: "Dave Newton" <dave@stripped>
> Cc: <java@stripped>
> Sent: Thursday, October 02, 2003 7:27 AM
> Subject: Re: Becoming a FAQ: Executing multiple sql
> statements in a single
> network round trip
> 
> 
> > I have potentially heavy load, and want to ensure
> that
> > I'm not using network bandwidth unnecessarily, so,
> > yes, I'm partly concerned about speed, but also
> about
> > resource utilization.  They kind of go hand in
> hand.
> >
> > --matthew
> >
> > --- Dave Newton <dave@stripped> wrote:
> > > On Wed, 2003-10-01 at 17:29, Matthew T. Adams
> wrote:
> > > > How do I do stuff (inserts, creates, updates)
> all
> > > in
> > > > one round trip?
> > >
> > > I'm curious why you need to--are you just
> concerned
> > > about connection
> > > speed?
> > >
> > > Dave
> > >
> > >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > The New Yahoo! Shopping - with improved product
> search
> > http://shopping.yahoo.com
> >
> > -- 
> > MySQL Java Mailing List
> > For list archives: http://lists.mysql.com/java
> > To unsubscribe:   
>
http://lists.mysql.com/java?unsub=1
> >
> >
> 
> 
> -- 
> MySQL Java Mailing List
> For list archives: http://lists.mysql.com/java
> To unsubscribe:   
>
http://lists.mysql.com/java?unsub=1
> 


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com