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

Groups > comp.lang.java.programmer > #14519 > unrolled thread

Slow Query Execution between two Servers

Back to article view | Back to comp.lang.java.programmer

Contents

  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

#14519 — Slow Query Execution between two Servers

Hi,
      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?

Cheers!

George

[toc] | [next] | [standalone]

#14542

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/

[toc] | [prev] | [next] | [standalone]

#14562

On Tue, 15 May 2012 08:16:53 +0200, Robert Klemme
<shortcutter@googlemail.com> wrote, quoted or indirectly quoted
someone who said :

>If you suspect it's the network then you could do a network trace and 
>look at the timing. 

You might try a free program called TCPOptimizer to suggest the best
settings to tweak your TCP/IP. http://www.speedguide.net/downloads.php
-- 
Roedy Green Canadian Mind Products
http://mindprod.com
Plants" with "leaves" no more efficient than today’s solar cells 
could out-compete real plants, crowding the biosphere with an
inedible foliage. Tough omnivorous "bacteria" could out-compete 
real bacteria: They could spread like blowing pollen, replicate 
swiftly, and reduce the biosphere to dust in a matter of days.
Dangerous replicators could easily be too tough, small, and 
rapidly spreading to stop -- at least if we make no preparation. 
We have trouble enough controlling viruses and fruit flies. 
~ Eric Drexler (born: 1955-04-25 age: 57)  
Engines of Creation: The Coming Era of Nanotechnology.
.

[toc] | [prev] | [next] | [standalone]

#14570

On 05/16/2012 01:05 PM, Roedy Green wrote:
> On Tue, 15 May 2012 08:16:53 +0200, Robert Klemme
> <shortcutter@googlemail.com>  wrote, quoted or indirectly quoted
> someone who said :
>
>> If you suspect it's the network then you could do a network trace and
>> look at the timing.
>
> You might try a free program called TCPOptimizer to suggest the best
> settings to tweak your TCP/IP. http://www.speedguide.net/downloads.php

Roedy, how should that help OP?  He said

> I am using Application in one Server and MySql DB in another
> server(Both are Linux).

Better look in the wireshark, pcap, tcpdump area.

Kind regards

	robert

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.java.programmer

csiph-web