Hi I have not used MySQL for a while and just noticed in the manual a feature called SQL_BUFFER_RESULT. I was wondering whether this is useful if I am writing an application in PHP (web based)? For example, if I did a select that returned 1000 rows, would PHP store the dataset in its memory and slowly feed the results to the client (say over a 28.8k modem), hence releasing the MySQL table lock instantly. If it does, is there a limit to the amount of data 'cached'? On a slightly different note - well done to everyone that has helped to bring 3.23 to stable. Thanks for you help Nick (Please reply by email - since I am not on the list - Thanks) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php