Re: Very slow when using remote server
Posted by: Todd Farmer
Date: January 17, 2012 10:17AM

Hi,

I didn't see your connection properties (here or in the Oracle forum post), so perhaps you have not set rewriteBatchedStatements=true? If this is the case, you may want to change this setting (default is false), and perhaps review the following presentation on "MySQL Connector/J Performance Gems", which includes this recommendation:

http://assets.en.oreilly.com/1/event/21/Connector_J%20Performance%20Gems%20Presentation.pdf

Beyond the client/server communication aspects, you may also want to evaluate the performance of the statement on the remote server. It's not uncommon that statements which execute quickly in development environments with limited load and smaller data sets perform worse when executed against production(-like) systems. Even simple INSERT statements can block temporarily on auto-increment key locking in high-concurrency deployments.

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/

Options: ReplyQuote


Subject
Written By
Posted
Re: Very slow when using remote server
January 17, 2012 10:17AM


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.