|
|
Posted by Chung Leong on 01/20/06 15:34
Jerry Stuckle wrote:
> For one thing - once you have it in an array, you can release your
> result set - freeing MySQL resources. And if you don't need the
> connection for anything else, you can close it. One of the big
> concurrency issues with RDB's is holding their resources longer than
> necessary.
>
> Also, if you're doing lots of complex processing on the returned data,
> it's generally better to buffer the data in your own program rather than
> hold it in MySQL.
>
It doesn't have to be complex, just time-consuming. An operation like
echo can potentially block for a very long time.
Navigation:
[Reply to this message]
|