Re: Spawned process, locked table.

2001-11-04 Thread Jeremy Zawodny
On Sun, Nov 04, 2001 at 09:06:02PM -0400, Corey Kaye wrote: > This is my Perl script. I though that adding $query->finish would > unlock the table but it didn't. It looks like the only way around > this is to connect/disconnect from the DB between each update. All > that connecting/disconnecti

Spawned process, locked table.

2001-11-04 Thread Corey Kaye
I'm writing a web application for a client in PHP. One function that a user can perform results in a very expensive update. To try and speed up this process (free up the user) i wrote a Perl script that performs the bulk of the work. When the user runs the PHP page, the PHP page updates one