MySQL Forums :: JDBC and Java :: Very slow when using remote server
Re: Very slow when using remote server
Posted by: Brian Sparacino ()
Date: January 17, 2012 04:59PM
rewriteBatchedStatements=true
this made a HUGE difference
my local server went from ~310ms to ~25ms -> 12x faster
my remote server went from ~32000ms to ~390ms -> 82x faster
this made a HUGE difference
my local server went from ~310ms to ~25ms -> 12x faster
my remote server went from ~32000ms to ~390ms -> 82x faster
| Subject | Written By | Posted |
|---|---|---|
| Very slow when using remote server | Brian Sparacino | 01/17/2012 08:26AM |
| Re: Very slow when using remote server | Todd Farmer | 01/17/2012 10:17AM |
| Re: Very slow when using remote server | Brian Sparacino | 01/17/2012 11:40AM |
| Re: Very slow when using remote server | Brian Sparacino | 01/17/2012 04:59PM |
| Re: Very slow when using remote server | Todd Farmer | 01/17/2012 06:16PM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates