Re: [SPAM] Re: [SPAM] Re: [GENERAL] Best practices to manage custom statistics

2016-11-24 Thread Adrian Klaver
On 11/24/2016 09:59 AM, Moreno Andreo wrote: Hi Adrian, First of all: now I've seen that not all fields touched by WHERE Aah, I get it now. You are refreshing forms every 60 seconds over 350 users each with their own database. Actually worse then that as there is user overlap over

Re: [SPAM] Re: [SPAM] Re: [GENERAL] Best practices to manage custom statistics

2016-11-24 Thread Moreno Andreo
Hi Adrian, First of all: now I've seen that not all fields touched by WHERE clauses in queries are indexed. Time to try some indices and EXPLAIN a bit (I must be blind... I've checked it multiple times) Scroll down for the rest of the thread. Il 23/11/2016 16:59, Adrian Klaver