Current recordset does not support updating adodb
The data array for the current row is stored in the fields property of the recordset object, $rs.
Move Next( ) offers the highest performance among all the techniques for iterating through a recordset: The default is ADODB_FETCH_BOTH for Oracle.
The wide range of choices is confusing to someone just starting with Oracle and PHP.
I will briefly summarize the differences, and show you the advantages of using ADOdb.
It is also good for relieving heavily-loaded database servers.
This example will cache the following select statement for 3600 seconds (1 hour): There are analogous Cache Get Array( ), Cache Get Row( ), Cache Get One( ) and Cache Select Limit( ) functions.
Just in case you need it, here's a guide to installing Oracle and PHP on Linux. But if you need more power, you can see ADOdb offers more sophisticated functionality.
ADOdb tries to make things easy by assuming the LOB can fit into main memory.
For example, suppose we have a large array which needs to be inserted into an Oracle database.
The following will result in a massive speedup in query execution (at least 20-40%), as the SQL statement only needs to be compiled once: Oracle treats data which is more than 4000 bytes in length specially. Binary LOBs are BLOBs, and character LOBs are CLOBs.
First we have the C extensions which provide low-level access to Oracle functionality.
These C extensions are precompiled into PHP, or linked in dynamically when the web server starts up.