[GENERAL] Performance Low Using the Prepare and Execute

[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:: Prepare and Execute Manually) : 44.9510087967
Time of Execution (ADODB:: Prepare and Execute of ADODB): 47.6438999176
Time of Execution (ADODB:: Without Prepare): 47.6229438782

Test1 Code:

$sSQL = 'EXECUTE teste(\'teste0...............\')';

    for ( $i = 0; $i < $iNTestes; $i++ )
        $oDB->execute_query( $sSQL, __LINE__, __FILE__ );

Test2 Code:

$sSQL = 'INSERT INTO teste (nome) VALUES( ? )';

$oDB->Prepare( $sSQL );

    for ( $i = 0; $i < $iNTestes; $i++ )
        $oDB->ExecutePrepare( Array( 'teste1...............' ), __LINE__, 
__FILE__ );

Teste3 Code:

$sSQL = 'INSERT INTO teste (nome) VALUES(\'teste2...............\')';

    for ( $i = 0; $i < $iNTestes; $i++ )
        $bOk = $oDB->execute_query( $sSQL, __LINE__, __FILE__ );


The SQL that they use the Prepare and Execute would have to be lesser
than the others?

Thanks.

-- 
__________________
Marcos José Setim
[EMAIL PROTECTED]
http://www.linuxhard.org


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match