Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001051

Re: [PHP-DB] Performance of Stored Procedures ? From: Lokesh Wuluvarana (lokesh.wuluvarana <email protected>)
Date: 05/14/01

Well tuned (using appropriate indexes and following a good execution
plan) Queries work faster than procedures. If the query involves
mathematical computation or operations such as substr, concatenations,
then a PL/SQL procedure works better. It all depends what the quey is
doing.

Lokesh

"Thies C. Arntzen" wrote:
>
> 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
>
> --
> 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> 

-- 
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>