Change SQL Cache Method

[fontuna]

I currently am using zencart version 1.37 and am not caching my SQL file.

I would like to change the SQL cache to cache to file.

What files do I need to edit and what edits do I need to do to the files inorder to cache to file?

Thanks,

Adam Fontana

[DrByte]

There are 3 caching options:

1. None

2. Cache to File
In your /includes/configure.php and /admin/includes/configure.php files, you'll see this section, which explains the requirements:

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from:  none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash
define('SQL_CACHE_METHOD', 'file');
define('DIR_FS_SQL_CACHE', '/enter/your/path/to/public_html_or_htdocs/and/zencart/here/zen/cache');

3. Cache to Database
Caching to database can be enabled simply by setting SQL_CACHE_METHOD to 'database' ... in both configure.php files as mentioned in #2 above.

[Peekay]

What are the advantages and disadvantages of files Vs database?

[Peekay]

Well, I started with 'file' and that made a major improvement!

With the browser cache cleared, the homepage parse time reduced from 19 seconds to around 3. Actually, I'm surprised this isn't the default setting?

Gonna stick with 'file' unless there's a reason not to.

Next stop... Gzip.