[PHP-DB] Performance of Stored Procedures ?
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Performance of Stored Procedures ?
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Performance of Stored Procedures ?
Od: "Robert Boehrs" [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]