Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #14542

Re: Slow Query Execution between two Servers

Show all headers | View raw

On 11.05.2012 06:51, George wrote:
>        I am using Application in one Server and MySql DB in another
> server(Both are Linux). I am using the InitialContext and Datasource
> for connection using java.Here my problem is Slow in Query execution
> while calling from the application server. While I deploying the
> application and the MySql in the same server it is fast. Here I am
> using the LAN IP between two servers. How can I resolve this?

If you suspect it's the network then you could do a network trace and 
look at the timing.  Or use other network analysis tools.

You might also want to have a look at network buffer size settings. 
IIRC defaults in Linux are fairly low and if you transfer large query 
results buffer sizes can have an impact.

Kind regards

	robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Slow Query Execution between two Servers George <vijuitech@gmail.com> - 2012-05-10 21:51 -0700
  Re: Slow Query Execution between two Servers Robert Klemme <shortcutter@googlemail.com> - 2012-05-15 08:16 +0200
    Re: Slow Query Execution between two Servers Roedy Green <see_website@mindprod.com.invalid> - 2012-05-16 04:05 -0700
      Re: Slow Query Execution between two Servers Robert Klemme <shortcutter@googlemail.com> - 2012-05-17 11:16 +0200

csiph-web