View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002338 | SymmetricDS | Improvement | public | 2015-06-29 09:45 | 2019-04-23 12:17 |
| Reporter | ondrejhala | Assigned To | |||
| Priority | normal | ||||
| Status | new | Resolution | open | ||
| Product Version | 3.7.19 | ||||
| Summary | 0002338: Bulk Extract for MSSQL | ||||
| Description | When extracting big table containing BLOBs on MSSQL i get only about 2MB/s write speed to batch file. When i use the MSSQL bcp utility the speed is about 16+MB/s. It is min 8 times faster. Are you interested to implement the bulk extractor for MSSQL? It can speed up the extraction significantly. There is a configuration parameter in bcp in which you can setup the desired output format. https://msdn.microsoft.com/en-us/library/ms191516.aspx | ||||
| Additional Information | Performance comparion - selects and string operations are included also: http://florianreischl.blogspot.de/2012/03/performance-comparison-of-sql-server.html | ||||
| Tags | bulk, dialect: sql-server | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-06-29 09:45 | ondrejhala | New Issue | |
| 2015-06-29 09:46 | ondrejhala | Tag Attached: bulk | |
| 2015-06-29 09:46 | ondrejhala | Tag Attached: extract | |
| 2015-06-29 09:46 | ondrejhala | Tag Attached: mssql | |
| 2015-06-29 09:47 | ondrejhala | Tag Attached: bcp | |
| 2019-04-12 12:46 | admin | Tag Detached: bcp | |
| 2019-04-12 16:35 | admin | Tag Renamed | bulk => bulk loader |
| 2019-04-23 12:17 | elong | Tag Detached: extract | |
| 2019-04-23 12:17 | elong | Tag Detached: bulk loader | |
| 2019-04-23 12:17 | elong | Tag Attached: bulk | |
| 2019-04-23 20:49 | admin | Tag Renamed | mssql => dialect: mssql |
| 2019-04-24 12:50 | admin | Tag Renamed | dialect: mssql => dialect: sql-server |