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
