Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.java.programmer > #14542
| Path | csiph.com!usenet.pasdenom.info!news.albasani.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail |
|---|---|
| From | Robert Klemme <shortcutter@googlemail.com> |
| Newsgroups | comp.lang.java.programmer |
| Subject | Re: Slow Query Execution between two Servers |
| Date | Tue, 15 May 2012 08:16:53 +0200 |
| Lines | 22 |
| Message-ID | <a1eamsF42kU1@mid.individual.net> (permalink) |
| References | <2cc4e775-ff85-40ec-8f50-afad1d13c9f3@to5g2000pbc.googlegroups.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=ISO-8859-1; format=flowed |
| Content-Transfer-Encoding | 7bit |
| X-Trace | individual.net Ef1f14JlS6CERN5zj/VbGgUKO9IG88591iybBRXjoChy8IH9OucuJY9BC6J6onGTw= |
| Cancel-Lock | sha1:Hs5V6XC0dkC7ECIkpP4LJHmacPY= |
| User-Agent | Mozilla/5.0 (Windows NT 6.0; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 |
| In-Reply-To | <2cc4e775-ff85-40ec-8f50-afad1d13c9f3@to5g2000pbc.googlegroups.com> |
| Xref | csiph.com comp.lang.java.programmer:14542 |
Show key headers only | 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
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