Re: Performance of Stored Procedures ?

Here's a guess on the speed difference. It really depends on when the stored procedure is compiled. When astored procedure is compiled, a query plan is created based on the distribution of the data and the indices that were available at that point in time. So it is possible for a simple select statement to be faster than a stored procedure if the stored procedure is using stale information. The way you do your benchmarks can significantly affect the timings also. Can you share your benchmarks with us? Regards, John Robert Boehrs <RBoehrs@music-united.com> wrote in message news:0AF1B047BDAAD4119C01000102B0367C05389E@UNITED01... > 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? > > Any comments welcome > > Robert > > -- > 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 >