6 May
2015
6 May
'15
4:20 p.m.
On 06/05/15 21:20, Juha Heinanen wrote:
Daniel-Constantin Mierla writes:
It allows to make clear indexes (no bitwise and no module operations in
match expression), that speeds up a lot. Anyhow, the main issue was that
the old implementation was working for mysql (and perhaps postgress) only.
I think this is a fix and still ok to apply in
this testing phase. There
is no new feature comparing with previous stable, but making it be the
same in functionality. However, I wanted to check with all devs and see
other opinions. And again, it is only about db_mode=DB_ONLY for
usrloc.
what is the performance impact of this compared to the present raw query
implementation that fetches id modulo x from location table?
also, is there any performance implications on normal lookups and saves
in db only mode?
lookup is not affected at all. update of existing record is not
affected
as well. first registration (insert) will set an extra column with
integer value.
Daniel
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - http://www.kamailioworld.com