On 29/02/16 09:21, Juha Heinanen wrote: > Daniel-Constantin Mierla writes: > >>> Also, an index on connection_id would need to be created for location >>> table. >> there is already a connection_id in the database table location? Or do >> you mean something else? > Yes, but no index on it. Without an index, it may take a long time to > delete a record based on connection_id. > ohh, it was apparently too early, I missed the 'index'.
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. 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. Cheers, Daniel -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio Advanced Training, Berlin, March 7-9, 2016 - http://www.asipto.com _______________________________________________ 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