Re: Poor Performance with tables over 1Million entries

[József Rekedt-Nagy]

thanks, but that makes no difference (have tried ofc)

Aftab Khan Wrote:
-------------------------------------------------------
> 2. Used OR and Group By with Having: ~0.3sec
> SELECT * FROM DataMap
> WHERE dataId IN (1,2,3)
> GROUP BY itemId
> HAVING COUNT(dataId)=3
> LIMIT 20
>
> I Replaced
> dataId=1 OR dataId=2 OR dataId=3
> with
> dataId IN (1,2,3)
>
> hopefully you will see a speed difference



Edited 2 time(s). Last edit at 04/09/2009 04:28AM by József Rekedt-Nagy.