Daniel-Constantin Mierla writes:

> The index can be useful if there is an operation in the config file,
> because I think the module doesn't do any match internally only on this
> column.

It is possible to save connection_id to hash table based on source
ip/port and then on connection close add sql_query() call to config that
removes the location table entry.

> Also, it may be needed to be done in relation with server_id, if the
> same location table is shared between different server instances that
> use server_id identifiers.

So the index would be:

CONSTRAINT connection_idx UNIQUE (`server_id`, `connection_id`)

-- Juha

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Reply via email to