[Serusers] LCR question

Bjorn Asmul bjorn at atlasvoice.com
Tue Nov 15 17:51:35 CET 2005


What indexes would you recommend on the LCR table?

-- Bjorn 

-----Original Message-----
From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] On
Behalf Of Juha Heinanen
Sent: Saturday, November 12, 2005 8:48 AM
To: Stefan Prelle
Cc: serusers at lists.iptel.org
Subject: [Serusers] LCR question

Stefan Prelle writes:

 > I am having huge performance problems. The OpenSER drops to
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 at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers




More information about the sr-users mailing list