Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001051

Odp: [PHP-DB] Performance of Stored Procedures ? From: Jarek Zgoda (jarekz <email protected>)
Date: 05/14/01

Od: "Robert Boehrs" <RBoehrs <email protected>>
Temat: [PHP-DB] Performance of Stored Procedures ?

> i've just made some simple test with oracle and stored procedures. I've
used
> a simple select-statement within the stored procedure and the same query
for
> a direct query within php.
> The direct query was about 50% faster. Is that normal? Will the stored
> procedures become faster with more complex queries?

Most of performance benefit you will get when performing complex
computations on data, such calculating taxes, rebates and other things.
Selects are not too good examples.

Cheers
Jarek Zgoda

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>