Working With Oracle on Windows: Part 1 - Conclusion (Page 3 of 3 )
We have now used PHP, Apache with Oracle. This combination can be quite effective. We have the user-friendly PHP, which is very effective and is embedded into the HTML code. PHP like ASP has a much lower cost compared to the likes of Perl and C/C++ compiled CGI files.
Although there are short cuts for these languages such as Fast CGI, Mod-Perl, and ISAPI, PHP’s greatest advantage is that the constructed for the world wide web, as opposed to C/C++ and Perl, in which there development commenced before the www. Hence, it became popular and more efficient then its predecessors. Apache’s greatest pitch is due to the fact, like PHP, it is open source.
It uses a basic connection pool and accepts the likes of PHP and Oracle. Then we have Oracle which has been around for a long time, structure data efficiently and securely. We will now consider some alternatives to Oracle.
Another database that we could use is MySQL. MySQL is open source, so you may use a download the latest version online. But when you are sitting in the meeting room, discussing cost/benefits the following question continues to be raised, "What data structure should we use and will it be too expensive for what we are after?" Well, MySQL is fast, efficient and inexpensive, while Oracle is renowned for its powerful data manipulations and data safety tools.
The reason why we would you use Oracle is because of its scalability and data security content. This means that if you require a database which will be used for a large number of transactions, Oracle would deem much more reliable and secure. It comes down to how much one is willing to pay for efficient data structuring.
If you are creating a website which requires little use of data storage and not at all worried about security you may even use PHP to read and write into a text file with fields separated by delimiters. This is not wise though due to self explanatory reasons. A high performance website sometimes requires high performance software. So it really boils down to how much you are willing to pay to get the results you require.
DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.