On Thu, Jan 02, 2003 at 07:21:24PM -0500, Jeff Thies wrote: > I've writen a lot of DBI code (CGI) for *nix/MySQL and never worried > about closing statement handles: $sth->finish(). I assumed that when the > script was done and it would tidy this up. > > Is this different on the windows/Access side? Is this something I > should have been doing all along on *nix?
You only need to call finish() for SELECT handles, and only when you don't select all the rows, either with fetchall_... or calling fetch_... in a loop, or something like that. > Should I worry about closing the database handle? It is good practice to close the database handle explicitly. Ronald
