提交給mysql java驅動的最佳化下個版本要發布了^_^

標籤：

Unsubscribe from updates to this bug at: https://bugs.mysql.com/77681 Updated by:  Daniel che chung So Reported by: OCA Admin Category:    Connector/J Severity:    S3 (Non-critical)-Status:      In progress+Status:      Closed Version:     5.1.x OS:          Any[20 Aug 23:25] Daniel che chung SoAdded the following entry to the Connector/J 5.1.37 changelog:"The code for executing a REPLACE statement whenrewriteBatchedStatements=true has been refactored by putting multiplebatched statements into a single query, making it work more like anINSERT statement. This increases the efficiency for running REPLACEstatements. Thanks to Jie Han for contributing the patch."------------------------------------------------------------------------[21 Jul 9:17] jie hanwe have billions records transfer from offline to online ,  rewritereplace statement will save lots of bytes. and rewirte to one sql meansdon‘t need  explicitly begin transaction ,because one sql will executein  a standalone transaction when autocommit is true,this save tworequest for every batch. where network is slow autocommit will save moretime. hope rewrite replace statement will release in next version.------------------------------------------------------------------------[20 Jul 17:27] Filipe SilvaBug#40561 is a duplicate of this.------------------------------------------------------------------------[12 Jul 8:00] Umesh UmeshHello!Thank you for the report and contribution.Thanks,Umesh

 

提交給mysql java驅動的最佳化下個版本要發布了^_^