Hmm.... This is because mysql is "dumb" :( Anyway, if you wanted quoted digits, there is an option to enable that in the mod_lcr config file.
http://wiki.freeswitch.org/wiki/Mod_lcr#Advanced_Usage Specifically, look at the parameter: quote_in_list The most efficient way (that I know of) to use mod_lcr is to use postgresql and the prefix postgres module which uses a custom datatype and a GIST index for the prefix column. On Thu, Sep 17, 2009 at 9:24 PM, Marcelo Sosa - LST <[email protected]> wrote: > Hello all, > > This is my first message on the list, i´m pretty new to FS. > I was playing a bit with mod_lcr and found that the sql query for fetching > the lowest rate can be changed to a better use of indexes, at least on > mysql. Anyone can do some test using other DBs? > > The change i've made was simple, the original query was something about "... > AND digits IN (12345, 1234, 123, 12, 1) ..." and using EXPLAIN i saw that it > was using carrier_id as key for the biggest table and not digits. I've > changed the code so the query is " AND (digits='12345' OR digits='1234' OR > digits='123' OR digits='12' OR digits='1') " and mysql uses the index from > the digits row, reducing the returned resultset of the subquery from all the > digits from a carrier to the number of "OR" in the query (in my case, from > 19850+ to 14). > > Anyone think that this may be a nice change? or it is just a bad use of > indexes by mysql? > > Regards, > Marcelo Sosa > _______________________________________________ > FreeSWITCH-users mailing list > [email protected] > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users > http://www.freeswitch.org > > -- -Rupa _______________________________________________ FreeSWITCH-users mailing list [email protected] http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
