php-db | 2001051
Date: 05/14/01
- Next message: Andrew Hill: "RE: [PHP-DB] php -> MSSQL"
- Previous message: Jordan Elver: "Re: [PHP-DB] Printing out usernames and logins"
- In reply to: Robert Boehrs: "[PHP-DB] Performance of Stored Procedures ?"
- Next in thread: John Lim: "Re: [PHP-DB] Performance of Stored Procedures ?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Od: "Robert Boehrs" <RBoehrs <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: 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>
- Next message: Andrew Hill: "RE: [PHP-DB] php -> MSSQL"
- Previous message: Jordan Elver: "Re: [PHP-DB] Printing out usernames and logins"
- In reply to: Robert Boehrs: "[PHP-DB] Performance of Stored Procedures ?"
- Next in thread: John Lim: "Re: [PHP-DB] Performance of Stored Procedures ?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

