[redland-dev] Free MySQL Connections

[Dave Beckett]

On Mon, 10 Jan 2005 19:54:16 +0200, Simon Cross <simon at sanbi.ac.za> wrote:

> Greetings,
> 
> I'm using the Redland PHP bindings.  If I perform a query but stop
> iterating through the results before they've been exhausted then MySQL
> connections are left hanging until the process exits.  If I iterate all
> the way through the results then the connections get closed.
> 
> I'd like to have the temporary connections associated with the query be
> closed once the result and query have been freed (even if the full
> results weren't used).
> 
> Any idea how I could achieve this?

It should be freeing the connections when you free the result and query;
it's all streaming and should handle partial results.  I'll see if I
can work out where this is happening.

Dave