Re: [GENERAL] Performance Low Using the Prepare and Execute

2006-01-07 Thread Neil Conway
On Sat, 2006-01-07 at 20:38 +, Marcos José Setim wrote: > I want to use the Prepare and Execute resources of PostgreSQL to > increment the performance of my SQL's. > $sSQL = 'INSERT INTO teste (nome) VALUES( ? )'; > > $oDB->Prepare( $sSQL ); The PREPARE documentation states:[1] Prep

[GENERAL] Performance Low Using the Prepare and Execute

2006-01-07 Thread Marcos José Setim
Hi, I want to use the Prepare and Execute resources of PostgreSQL to increment the performance of my SQL's. I do tests using the PHP and ADODB inserting 5000 registers and counting the time of execution. But the results was pratically identical. See below the results: Time of Execution (ADODB