Hi
We have noticed when using pua module with db_mode set to 1 the lock type defaults to DB_LOCKING_WRITE which locks the whole table and can cause performance issues.
I noticed this fix for the presence module last year specifically on this issue: http://lists.kamailio.net/pipermail/sr-dev/2014-January/022820.html
I've attached an almost identical patch for pua I want to commit. The patch makes this a configurable parameter that defaults to DB_LOCKING_WRIT.
If no one raises any concerns I will go ahead and commit.
Regards Richard.