Introduced cache class which leverages both Memcached or Memcache if installed - Memcache(d) servers are defined within your /inc/loader.php file - Default values match that of Memcache(d) servers locally and will automatically work as soon as the memcache(d) plugin is avalible within your PHP config.
Fixed bug in get_benchmark_formatted() when there was no data available - Only occurs now all queries on a page can be cached
- Large refactor to optimise MySQL PDO connections where possible
- Queries will now cache within Memcache(d) where possible to largely reduce overhead on your DB - Currently not working with cache breaking - MySQL DB update coming shortly - using triggers & stored procedures to track the last mod times of tables for automatic cache invalidating
- $this->query() params changed, now you only need to call $this->query($sql, $params, $options('fetch' => 'array')); if you want to get an array - This removes the need for checking numrows and makes everything smoother - Make caching query result sets a lot simpler - There will be further code refinements here shortly as it's currently very clunky however the functionality now implemented will remain the same going forward.
Bug fix, __construct refactored to __init
db->query() call updated following db->query() refactor to make future calls cacheable & simpler
Bug fix, options weren't being passed correctly in get_nav() to where clauses weren't being applied as expected
PHP Notice fix where $this->pid isn't always set
MySQL query optimisation following changes of indexes on `pages` table
Disabled MySQL benchmarking