the InnoDB engine.
I was curious if there are any problems where doing a read on a large
dataset has huge problems down the road. Let's assume the server is a quad
core with 4 GB of RAM. Surely it shouldn't have a *huge* effect?
Sincerely,
Suhail Doshi
ing the event_ids in your IN() list to a temp table &
> joining to that table?
>
> PB
>
> -
>
> Suhail Doshi wrote:
>
> Having problems with this query, any ideas on how to optimize this further?
>
> mysql> explain SELECT cache_propert
Having problems with this query, any ideas on how to optimize this further?
mysql> explain SELECT cache_property_str.name as name,
SUM(cache_property_str.tally) as count
FROM cache_property_str
WHERE
cache_property_str.status = 1 AND
