[PHP] PDO::prepare deallocate PDOStatement::closeCursor()

2006-12-15 Thread Yonatan Ben-Nes
Hi all, I got 2 questions about PDO: 1. Let's say that I create the following prepared statement: $PDOStatement = $DB_Conn-prepare(INSERT INTO test (name) values (?)); And after 50,000 inserts (with $PDOStatement-execute(array('somevalue'));) I want the database to analyze, compile and optimize

Re: [PHP] PDO::prepare deallocate PDOStatement::closeCursor()

2006-12-15 Thread Richard Lynch
On Fri, December 15, 2006 7:49 am, Yonatan Ben-Nes wrote: 1. Let's say that I create the following prepared statement: $PDOStatement = $DB_Conn-prepare(INSERT INTO test (name) values (?)); And after 50,000 inserts (with $PDOStatement-execute(array('somevalue'));) I want the database to