What indexes would you recommend on the LCR table? -- Bjorn -----Original Message----- From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Juha Heinanen Sent: Saturday, November 12, 2005 8:48 AM To: Stefan Prelle Cc: serusers(a)lists.iptel.org Subject: [Serusers] LCR question Stefan Prelle writes: effectivly > 1 CPS. My lcr table contains only 20 entries and I have just 2 gateways > configured, so this shouldn't be a problem. currently load_gws() makes a complex mysql query, but only one mysql query per second seems very slow to me. load_gws could be rewritten totally in c, but so far nobody has had time to do so. -- juha _______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers