On 01/03/16 08:59, Juha Heinanen wrote: > Juha Heinanen writes: > >> So the index would be: >> >> CONSTRAINT connection_idx UNIQUE (`server_id`, `connection_id`) > I added the index. Should also version number be updated in case some > people do db upgrades automatically when version changes? > I don't think this is needed, the structure is the same and the module doesn't need the index internally -- practically nothing changes from module point of view.
When someone is doing sql_query() from config, it may need other indexes anyhow... it should review each query it is done and optimize as needed. 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