View Issue Details

IDProjectCategoryView StatusLast Update
0001422SymmetricDSImprovementpublic2019-08-26 12:45
Reporterabrougher Assigned Toelong  
Prioritynormal 
Status closedResolutionopen 
Product Version3.5.7 
Summary0001422: Support the ability to sync triggers without querying all of the tables' metadata.
DescriptionThere should be a method to call sync triggers and only synchronize triggers that have been modified. When syncing triggers, it would not be necessary to query the table meta data to check for schema changes.

This should significantly increase the speed of the Sync Trigger process.

Tagstrigger

Activities

elong

2019-04-22 13:28

developer   ~0001414

I believe it works this way today, where a change to sym_trigger causes sync triggers to run for just that entry. When the sync triggers job is run on the schedule, it still inspects all sym_trigger configuration and table metadata. Maybe we should not run that job on startup any more, since it was a historical way to sync triggers before it could detect individual trigger changes? Should we update this issue?

admin

2019-08-26 12:45

administrator   ~0001591

Auto closing all issues waiting for feedback after 4 months. We don't have enough information to take any action.

Issue History

Date Modified Username Field Change
2013-09-18 17:08 abrougher New Issue
2013-09-20 15:26 abrougher Description Updated View Revisions
2019-04-22 13:28 elong Assigned To => elong
2019-04-22 13:28 elong Status new => feedback
2019-04-22 13:28 elong Note Added: 0001414
2019-04-22 13:28 elong Tag Attached: trigger
2019-08-26 12:45 admin Note Added: 0001591
2019-08-26 12:45 admin Status feedback => closed