-
Book Overview & Buying
-
Table Of Contents
PHP Oracle Web Development: Data processing, Security, Caching, XML, Web Services, and Ajax
By :
While developing PHP/Oracle applications, you may find that implementing some data processing operations by means of PHP can be very difficult to accomplish, as well as inefficient in terms of performance. For example, using PHP, if you need to calculate the average value of all the values in a specific database table column with a numeric data type, first you will have to retrieve all these values from the database and then process them using custom PHP code. Obviously, this solution increases the network overhead and slows down the performance. In this case, using the AVG built-in Oracle SQL function in the query would allow you to achieve the same general result with less overhead.
From the examples given in the preceding chapters, you learned how to use SQL statements to access data stored in the database. This section discusses how you can design SQL statements to offload data processing from the web/PHP server to the database server.
Change the font size
Change margin width
Change background colour