[
https://issues.apache.org/jira/browse/SQOOP-387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13143501#comment-13143501
]
Bilung Lee commented on SQOOP-387:
----------------------------------
Thanks for your contribution! One comment. Instead of overriding the whole
migrateData and deleteAllRecords methods, how about having a getDeleteQuery
method to return the DELETE statement in SqlManager? Then, use it in
migrateData/deleteAllRecords methods of SqlManager and only override that in
PostgreSQLManager to return TRUNCATE statement?
> Use TRUNCATE for PostgreSQLManager
> ----------------------------------
>
> Key: SQOOP-387
> URL: https://issues.apache.org/jira/browse/SQOOP-387
> Project: Sqoop
> Issue Type: Improvement
> Components: connectors/postgresql
> Reporter: Shinichi Yamashita
> Attachments: SQOOP-387.patch
>
>
> PostgreSQLManager uses "DELETE" sentence for procesing in staging-table.
> When it does "EXPORT" many times, the processing time is prolonged in
> "DELETE".
> Therefore replace it with "TRUNCATE" sentence and improve performance.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
