- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:reference:adodb_cache_dir

# $ADODB_CACHE_DIR

Type | String
Default | empty

## Description

If you are using recordset caching, this is the directory to save your recordsets in. There is no default definition . Define this before you call any caching functions such as cacheexecute.

If using this feature with PHP versions less than 5.4 we recommend setting _register_globals=off_ in php.ini for security reasons.

## Performance considerations

The speed of the query retrieval is dependent on the systems ability to read text files from a file system. Consider placing the cached queries on an SSD if available, or an in-memory filesystem

## Syntax

    $ADODB_CACHE_DIR='/home/adodb/caching';
    $SQL = "SELECT * FROM large_table";
    $db->cacheExecute($SQL);

## Recommended PHP Configuration

    register_globals=off

## Unix Configuration

You might need to set your cache directory permissions to something similar to the following:

    chown -R apache /path/to/adodb/cache
    chgrp -R apache /path/to/adodb/cache

## Windows Configuration

The directory that is used to save the cache files must be readable and writable by the IIS owner process.

v5/reference/adodb_cache_dir.txt · Last modified: 2016/01/17 15:44 by 66.249.75.217

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top