On Mon, Feb 8, 2010 at 3:37 PM, Steve Staples <sstap...@mnsi.net> wrote:
> Hi there. > > I was reading last week (and of course, i can't find it now) something > about > 'nicifying' a query, so taht it doesn't lock the table... > > How is this done? I've read so much stuff lately, that i can't find it > for > the life of me, and google is not being my friend :( > Maybe Google feels that you haven't been a partiicularly good friend to them, of late ? :-) "Nicifying" a query is not something you can write a manual for, alas. EXPLAIN your queries. If you need little data, see if you can pad it to the index you use - that'll prevent additional disk reads. InnoDB will help your inserts not block. Avoid full table scans. Avoid outer joins, they cause full table scans. et cetera ad nauseam. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
