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

[Matthew T. Adams]

I didn't realize that he wrote it.  My bad -- sorry. 
I guess I was thinking that using a batch of
statements, a la Statement.executeBatch() would work,
but since no one mentioned it, and I dug a little
deeper, I don't think it will, either.

I think my best bet is to wait for server-side
prepared statement support in 4.1 and use that.

Sorry for my dumb mysql newbie questions...

--matthew
  
--- Paul DuBois <paul@stripped> wrote:
> At 9:56 -0700 10/2/03, Matthew T. Adams wrote:
> >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?
> 
> Mark Matthews has already answered your question.
> He *wrote* Connector/J, so his answer is
> authoritative.
> Why is it that you appear not to believe his answer?
> 
> 
> >
> >--- Christopher Taylor <cstaylor@stripped> wrote:
> >>  Are you mostly making queries?  Why not cache
> that
> >>  information instead of
> >>  going to the database everytime?
> >>
> >  > -Chris
> 
> 
> -- 
> Paul DuBois, Senior Technical Writer
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
> 
> Are you MySQL certified? 
> http://www.mysql.com/certification/
> 


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