Odp: [PHP-DB] Performance of Stored Procedures ?
| From: | Jarek Zgoda | Date: | Mon, 14 May 2001 13:04:13 +0000 |
| Subject: | Odp: [PHP-DB] Performance of Stored Procedures ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9295@lists.php.net to get a copy of this message | ||
Od: "Robert Boehrs" <RBoehrs@music-united.com>
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