Re: Performance of Stored Procedures ?
| From: | Thies C. Arntzen | Date: | Mon, 14 May 2001 12:53:16 +0000 |
| Subject: | Re: Performance of Stored Procedures ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9292@lists.php.net to get a copy of this message | ||
On Mon, May 14, 2001 at 02:52:01PM +0200, Robert Boehrs wrote:
> Hi,
>
> 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?
this pretty much depends on the code you write.
could you send me the code you used for your "little"
benchmark - so i could have a loot at it?
tc