List:MySQL and Java« Previous MessageNext Message »
From:Paul DuBois Date:October 2 2003 5:07pm
Subject:Re: Becoming a FAQ: Executing multiple sql statements in a single network round trip
View as plain text  
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/

Thread
Becoming a FAQ: Executing multiple sql statements in a single network round tripMatthew T. Adams1 Oct
  • Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripMark Matthews1 Oct
    • Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripMatthew T. Adams1 Oct
      • Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripMark Matthews1 Oct
Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripMatthew T. Adams2 Oct
  • Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripChristopher Taylor2 Oct
    • Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripMatthew T. Adams2 Oct
      • Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripPaul DuBois2 Oct
        • Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripMatthew T. Adams2 Oct
          • Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripPaul DuBois2 Oct
          • Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripChristopher Taylor3 Oct
            • Re: Becoming a FAQ: Executing multiple sql statements in a single network round tripMatthew T. Adams3 Oct
RE: Becoming a FAQ: Executing multiple sql statements in a single network round tripJR Ruggentaler2 Oct