[Serusers] Serweb or MySQL bug ?

[Jiri Kuthan]

I think the problem is that the sql query, which tries to capture both
calls to canonic username as well as aliases, has poor performance.
The list eventually shows up but the mysql joint construct simply takes
too long. The query should be reshaped into a faster one.

-jiri

At 08:44 PM 7/25/2003, Juan J. Sierralta P. wrote:
>Hi,
>
>        I'm accounting for missed calls onto MySQL everything fine. But Serweb
>doesn't show the missed calls so checking on missed_calls.php line 29:
>
>$q="select distinct t1.from_uri, t1.sip_from, t1.time, t1.sip_status
>from "
>        $config->table_missed_calls." t1, ".$config->table_aliases."
>t2".
>        " where t1.username='".$auth->auth["uname"].
>        "' OR ('sip:".$auth->auth["uname"]."@".$config->default_domain.
>            "'=t2.contact AND t2.username=t1.username) ".
>        " order by time desc";
>
>        Is the line that make the actual query to DB so I run the following
>queries on MySQL (v3.23.49):
>
>mysql> select t1.from_uri,t1.username from missed_calls t1 where
>t1.username='5624108980';
>+-----------------------------------------+------------+
>| from_uri                                | username   |
>+-----------------------------------------+------------+
>| sip:5624108990 at 192.168.65.14;user=phone | 5624108980 |
>+-----------------------------------------+------------+
>1 row in set (0.00 sec)
>
>        Fine so far, but if check for the something similar as serweb's query:
>
>mysql> select t1.from_uri,t1.username from missed_calls t1, aliases t2
>where t1.username='5624108980' OR ('5624108980 at marte'=t2.contact AND
>t2.username=t1.username);
>
>Empty set (0.01 sec)
>
>        If I understand correctly the idea of the query is to get that missed
>calls that match the username or an alias, in my case I have not aliases
>defined; but since the query uses OR for aliases part I don't know why
>the query gets an empty set.
>        BTW I'm no SQL fluent :)
>
>
>
>-- 
>Juanjo sin .sig :(
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers

--
Jiri Kuthan            http://iptel.org/~jiri/