You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Problem
Currently we have a mixture of insert only and update logic employed in the EntityRecordItemListener class.
Most domain objects are created and added to a list for batch insert later in EntityListener implementation e.g. SqlEntityListener.
However, items that require an update make the flow complex as they are currently run immediately.
The intent should be to batch insert and batch update all items.
Solution
Utilize the available cache manager by
Update EntityRecordItemListener to insert all items into the appropriate cache
Update EntityRecordItemListener to update the cache value when an update transaction is encountered for an item that was created in the same record file
Update EntityRecordItemListener to insert items created in previous record file into a separate cache
Update SqlEntityListener to batch insert (currently with PgCopy) all cache items in insert cache
Update SqlEntityListener to batch update (currently with Repository) all cache items in update cache
Alternatives
Update SqlEntityListeneron??? methods to do check for cache collisions and apply update/insert logic appropriately
Additional Context
The impact currently is that for now we have to keep checking if an item exists in the db prior to deciding how to handle an update transaction
The text was updated successfully, but these errors were encountered:
Problem
Currently we have a mixture of insert only and update logic employed in the
EntityRecordItemListener
class.Most domain objects are created and added to a list for batch insert later in
EntityListener
implementation e.g.SqlEntityListener
.However, items that require an update make the flow complex as they are currently run immediately.
The intent should be to batch insert and batch update all items.
Solution
Utilize the available cache manager by
EntityRecordItemListener
to insert all items into the appropriate cacheEntityRecordItemListener
to update the cache value when an update transaction is encountered for an item that was created in the same record fileEntityRecordItemListener
to insert items created in previous record file into a separate cacheSqlEntityListener
to batch insert (currently with PgCopy) all cache items in insert cacheSqlEntityListener
to batch update (currently with Repository) all cache items in update cacheAlternatives
SqlEntityListener
on???
methods to do check for cache collisions and apply update/insert logic appropriatelyAdditional Context
The impact currently is that for now we have to keep checking if an item exists in the db prior to deciding how to handle an update transaction
The text was updated successfully, but these errors were encountered: