Re: Performance of Stored Procedures ?

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@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net