http://php.weblogs.com/adodb Database wrapper library 1.10. Now supports cached recordsets. Example below: include('adodb.inc.php'); include('tohtml.inc.php'); $ADODB_CACHE_DIR = '/usr/local/adodbcache'; $conn = &ADONewConnection('oracle');/* Oracle 8, use 'oci8' */ $conn->PConnect('','scott','tiger'); $rs = $conn->CacheExecute(15,'select * from table'); rs2html($rs); /* recordset to html table */ The 15 in CacheExecute() indicates that the recordset will be cached for 15 seconds. Subsequent calls with this SQL statement will use the cached results until the 15 seconds expires. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
