LIMIT 10 doesn't limit very much in the query. It applies after the
group and count have happen - it's a limit on the results requirned, not
the work done in this query,
It has to do all the WHERE part in order to calculate the COUNT.
The query is returning any old 10 items (there is no
On 10/12/2018 04:24, Lee, Seokju | Daniel | TPDD wrote:
Hi Andy,
Thanks for the reply.
The in-memory dataset described above is fully transactional
Interesting that I didn't know that it is different from using TDB even I used
to use only for test purpose because I thought it is the same
