- 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_countrecs

# $ADODB_COUNTRECS

Type | Boolean
Default | True

##### See Also

po_recordcount

If a driver has native support for returning the number of records returned in an SELECT statement, then recordcount will automatically return the number of rows requested in the quert. In drivers that have no native support, then the result can be emulated by setting `$ADODB_COUNTRECS` to true before the statement is executed.

Note that if the value is set to true for databases without native support, the memory/query time overhead may be substantial for large recordsets. If the value is set to false then the value returned is always -1

## Syntax

    $SQL = "SELECT * FROM large_table";

    $ADODB_COUNTRECS = false;

    $db->Execute($SQL);

v5/reference/adodb_countrecs.txt · Last modified: 2016/01/16 18:11 by 66.249.75.209

### Page Tools

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