View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002338 | SymmetricDS Pro | Improvement | public | 2015-06-29 09:45 | 2025-03-17 20:15 |
| Reporter | ondrejhala | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.7.19 | ||||
| Target Version | 3.16.0 | Fixed in Version | 3.16.0 | ||
| 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, performance | ||||
| 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 |
| 2024-08-07 17:17 | pmarzullo | Relationship added | related to 0006551 |
| 2024-08-07 17:18 | pmarzullo | Assigned To | => elong |
| 2024-08-07 17:18 | pmarzullo | Status | new => resolved |
| 2024-08-07 17:18 | pmarzullo | Resolution | open => fixed |
| 2024-08-07 17:18 | pmarzullo | Fixed in Version | => 3.16.0 |
| 2024-08-07 17:19 | pmarzullo | Project | SymmetricDS => SymmetricDS Pro |
| 2025-03-17 17:15 | pbelov | Note Added: 0002703 | |
| 2025-03-17 17:15 | pbelov | Status | resolved => closed |
| 2025-03-17 20:15 | elong | Tag Attached: performance |