diff options
author | Mario Vavti <mario@mariovavti.com> | 2018-10-24 20:22:27 +0200 |
---|---|---|
committer | Mario Vavti <mario@mariovavti.com> | 2018-10-24 20:22:27 +0200 |
commit | 8b9acf750bde9b21551367f34e57ff549d7d3297 (patch) | |
tree | bd22753c7ff512bdd28c4c08f94ced2ca6532d3a /view/tpl/photosajax.tpl | |
parent | 01e11e904391504417f1a47c4fbb6277c154b5fd (diff) | |
download | volse-hubzilla-8b9acf750bde9b21551367f34e57ff549d7d3297.tar.gz volse-hubzilla-8b9acf750bde9b21551367f34e57ff549d7d3297.tar.bz2 volse-hubzilla-8b9acf750bde9b21551367f34e57ff549d7d3297.zip |
autocomplete performance: this slightly changes the editor contact autocomplete behaviour. queries using *like* with a prepended % to the query string do not make use of indices. this is no big issue when we query abook but can get really slow when xchan table is involved. this commit changes the xchan table only queries to use the *str%* format. this means that the result set for channels we are not connected with will change in a way that xchan_name and xchan_addr will bematched only from the beginning of the name or address. this commit also changes textcomplete to only start the query after the 3rd character. the result set between 2 and 3 characters is mostly very different and only from 3 chars on there is a high possibility the channel we look for is already in the result.
Diffstat (limited to 'view/tpl/photosajax.tpl')
0 files changed, 0 insertions, 0 deletions