[Serdev] [Tracker] Resolved: (SER-223) Patch to add support for REPLACE and delayed DB operations.

[Jan Janak (JIRA)]

     [ http://tracker.iptel.org/browse/SER-223?page=all ]

Jan Janak resolved SER-223.
---------------------------

    Resolution: Fixed

> Patch to add support for REPLACE and delayed DB operations.
> -----------------------------------------------------------
>
>                 Key: SER-223
>                 URL: http://tracker.iptel.org/browse/SER-223
>             Project: SER
>          Issue Type: Improvement
>          Components: Registrar
>    Affects Versions: Wishlist
>         Environment: Ottendorf code version from today.
>            Reporter: Nils Ohlmeier
>            Priority: Minor
>             Fix For: Wishlist
>
>         Attachments: usrloc_replace_and_delay.patch
>
>
> The attached patch adds:
> - support for the SQL command REPLACE instead of UPDATE if the database supports it. In scenarios where another entity deletes entries from the location table the UPDATE command would fail, but the REPLACE would succeed.
> - a separation of looking for required changes in the in-memory location and applying them to the DB. This should result in a shorter lock time of the in-memory location table, as the DB operations are applied after in-memory copies of the required changes are made. It can give you a little bit better performance for consuming more private memory.
> - an option for not deleting expired location table entries from the DB. Again this can give you a little bit better performance, but then another entity has to take care of cleaning the location table.
> Credits for this work go to Jan and Andrei!

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.iptel.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira