Re: Buffering SELECT results without using temporary tables; "Locked tables while 'Sending data'" revisited

2001-07-18 Thread Werner Stuerenburg
> (begins: http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/Mar.2000/1029.html ) By chance, this points me to an archive of this list. I already looked for a hint at the trailer and on the website, but, as I didn't find any, assumed that there wasn't any. Wouldn't it be helpful to add links at bot

Buffering SELECT results without using temporary tables; "Locked tables while 'Sending data'" revisited

2001-07-18 Thread Martin Ling
We are currently working with a table containing ~650MB of data in 700,000 rows. In attempting to select from this, we would typically find long holdups with process states listed as creating temporary tables. By using SQL_SMALL_RESULT we were able to greatly reduce the time taken for select oper