CodeIgniter is a powerful PHP framework with a very small footprint, built for PHP coders who need a simple and elegant toolkit to create full-featured web applications.It allows you to design the exact web app you need from the ground up.
Advantages of using codeigniter:
Disadvantages of using codeigniter:
You can use $result->free_result() to free the results, but sometimes this isn’t the root cause of excessive memory usage. Also, some calls (such as INSERTs) do not return a database object, so you can’t free() them. With very many INSERTs this can really bite you, as CI defaults to saving all your queries.
An undocumented CI feature is available to turn this off:
$this->db->save_queries = false;
There may be performance (caching) issues associated with disabling this across the board - ie. caution and experimentation is indicated.
Turn on profiling (part of the benchmarking class) - this will show the full detail of all the SQL queries for the page.
You can do this before your query:
.. and then this, once you’ve run the query:
You need to use the SQL AS feature, where you assign a new name to a piece of data, viz:
$this->db->select("COUNT('foo') AS foo_count", FALSE);
// Run your query, and then use the foo_count variable.