On 06/05/15 21:20, Juha Heinanen wrote:
Daniel-Constantin Mierla writes:
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?
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.
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