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