View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001302 | SymmetricDS | Improvement | public | 2013-06-27 19:59 | 2014-02-03 01:53 |
| Reporter | chenson | Assigned To | chenson | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.4.8 | ||||
| Target Version | 3.5.0 | Fixed in Version | 3.5.0 | ||
| Summary | 0001302: Speed up queries against sym_data, sym_data_gap and sym_outgoing_batch on postgres | ||||
| Description | Speed up queries against sym_data, sym_data_gap and sym_outgoing_batch on postgres. The jdbc driver should be using the Types.BIGINT versus Types.NUMERIC to bind against data_id and batch_id. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: master bf4cea55 2013-06-27 15:59:34 Details Diff |
0001302: Speed up queries against sym_data, sym_data_gap and sym_outgoing_batch on postgres |
Affected Issues 0001302 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/postgresql/PostgreSqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ISymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapRouteReader.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/IncomingBatchService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/OutgoingBatchService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-06-27 19:59 | chenson | New Issue | |
| 2013-06-27 19:59 | chenson | Status | new => assigned |
| 2013-06-27 19:59 | chenson | Assigned To | => chenson |
| 2013-06-27 20:02 | chenson | Status | assigned => resolved |
| 2013-06-27 20:02 | chenson | Fixed in Version | => 3.5.0 |
| 2013-06-27 20:02 | chenson | Resolution | open => fixed |
| 2013-07-22 21:51 | chenson | Note Added: 0000316 | |
| 2013-07-22 21:51 | chenson | Status | resolved => closed |
| 2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r7459 | |
| 2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master bf4cea55 |