Klaus,
>>in this case, I suspect, is that the disconnect happens in the
>> pre-data-sending stage, which is possibly quite lengthy.
> Exactly ! It takes hours till these results are erased and i even don't know
> where the period when they are erased come from.
> I still hope this is set in a ser
The problem is, that i can't prevent queries like
SELECT * FROM WHERE LIKE 'a%'
where an index will not help on a Table > 100.000.000 records.
It's not that we have to answer hese queries (therefore the timeout), but
it's impossible to prevent dumm users.
Run EXPLAIN on the untrusted queries f
Hi Sacha,
Thx a lot for your reply
you wrote:
>in this case, I suspect, is that the disconnect happens in the
pre-data-sending
>stage, which is possibly quite lengthy.
Exactly ! It takes hours till these results are erased and i even don't know
where the period when they are erased come from.
