Jeremy Zawodny wrote: > On Wed, Nov 14, 2001 at 12:07:04PM -0800, Bill Adams wrote: > > The most important exception is the mysql_use_result attribute: This > > forces the driver to use mysql_use_result rather than > > mysql_store_result. The former is faster and less memory consuming, > > but tends to block other processes. (That's why mysql_store_result > > is the default.) > > What does "block other processes" really mean? Does it mean "MySQL > will hold the lock longer for the query because of the network I/O" or > something completely different?
I think it is referring to the situation where the table only has table level locking and the client fetches some returned rows --but not all rows-- and holds the statement handle open. Then the table may be locked until the client program closes the handle or finishes fetching the results. But I could be 100% wrong on this. I have not tested this theory. b. --------------------------------------------------------------------- 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
