/opencart-mysql-cache

Caching MySQL SELECT queries for OpenCart 1.4/1.5/2.0

Primary LanguagePHP

OpenCart 2.0 compatible (beta, thanks to @aruncnt)

OpenCart 1.4.x/1.5.x stable version:
https://github.com/shaman/opencart-mysql-cache/tree/1.4/1.5

1. Copy mysql_cached.php file into the /system/library/database
2. Change /config.php file only:

  define('DB_DRIVER', 'mysql_cached');
  define('DB_CACHED_EXPIRE', 120);

3. For reset SQL cache, you can save in cache with key 'sql_globalresetcache' current time (time()).