View Issue Details

IDProjectCategoryView StatusLast Update
0006104SymmetricDSImprovementpublic2023-11-10 21:00
Reporteremiller Assigned Toemiller  
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.1Fixed in Version3.15.1 
Summary0006104: Add indexes to sym_outgoing_batch
DescriptionThe following 2 indexes have been found to improve performance when added to sym_outgoing_batch on a SQL Server database:

CREATE INDEX [NCLIX_sym_outgoing_batch_channel_id_status] ON [sym_outgoing_batch] ([channel_id], [status]) WITH (FILLFACTOR=80, ONLINE =ON);
CREATE INDEX [NCLIX_sym_outgoing_batch_node_id_channel_id_summary_Includes] ON [sym_outgoing_batch] ([node_id], [channel_id], [summary]) INCLUDE ([status], [create_time], [byte_count], [data_row_count], [load_millis]) WITH (FILLFACTOR=80, ONLINE =ON);

It would be good to add these indexes to sym_outgoing_batch by default.



2023-11-10 20:04

developer   ~0002397

We looked at the various queries that SymmetricDS runs on sym_outgoing_batch and decided it would be best to add the channel_id column to one of the existing indexes instead of adding 2 more.

Related Changesets

SymmetricDS: 3.15 3104ed53

2023-11-10 20:03:11


Details Diff
0006104: Added channel_id to index on sym_outgoing_batch Affected Issues
mod - symmetric-core/src/main/resources/symmetric-schema.xml Diff File

Issue History

Date Modified Username Field Change
2023-11-08 19:36 emiller New Issue
2023-11-08 19:36 emiller Status new => assigned
2023-11-08 19:36 emiller Assigned To => emiller
2023-11-08 19:36 emiller Tag Attached: schema
2023-11-10 20:04 emiller Status assigned => resolved
2023-11-10 20:04 emiller Resolution open => fixed
2023-11-10 20:04 emiller Fixed in Version => 3.15.1
2023-11-10 20:04 emiller Note Added: 0002397
2023-11-10 21:00 Changeset attached => SymmetricDS 3.15 3104ed53
2023-11-14 21:10 admin Status resolved => closed