[Wolves] mysql select help

Mark Rogers mark at quarella.co.uk
Wed Mar 14 12:09:03 UTC 2012

On 14/03/12 08:08, Andy D'Arcy Jewell wrote:
> MySQL will not use indexes when querying tables which fit wholly in memory, 
> although it will of course keep them up to date during inserts, so they are 
> really just an overhead on genuinely small tables. The online MySQL manual 
> gives a thorough discussion of how this works (look up "optimizing queries").

I guess I'm just not used to having tables that fit into memory! More a sign 
of how much memory I have than the size of my tables though!


Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450
Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER

More information about the Wolves mailing list