You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/10/18 13:56:38 UTC

[GitHub] [shardingsphere] avalon5666 opened a new issue #7836: Optimization scaling importer performance

avalon5666 opened a new issue #7836:
URL: https://github.com/apache/shardingsphere/issues/7836


   We can merge and batch execute the rows change to optimization performance.
   
   ## Merge
   
   insert + insert -> it's possible happed?
   insert + update -> insert 
   insert + delete -> delete
   update + insert -> it's possible happed?
   update + update -> update
   update + delete -> delete
   delete + insert -> delete,insert
   delete + update -> it's possible happed?
   delete + delete -> delete
   
   ## Batch Execute
   
   1. delete
   2. insert
   3. update


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] Lucas-307 commented on issue #7836: Optimization scaling importer performance

Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7836:
URL: https://github.com/apache/shardingsphere/issues/7836#issuecomment-711488216


   Good job.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] avalon5666 closed issue #7836: Optimization scaling importer performance

Posted by GitBox <gi...@apache.org>.
avalon5666 closed issue #7836:
URL: https://github.com/apache/shardingsphere/issues/7836


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] Lucas-307 commented on issue #7836: Optimization scaling importer performance

Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #7836:
URL: https://github.com/apache/shardingsphere/issues/7836#issuecomment-712563313


   Case 2: `insert + update -> insert`
   
   If the program occur exception after a data inserted, and then this data updated.
   By resume from break-point dumper back off, program received `insert + update`, which will merge to `insert`.
   This data will **ignored** by `INSERT IGNORE` sql .
   
   So maybe you should use `REPLACE INTO` sql or other plans. 


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org