====== $ADODB_COUNTRECS ======
<WRAP right box round>

|Type|Boolean|
|Default|True|

== See Also ==
[[v5:reference:connection:po_recordcount]]
</WRAP>

If a driver has native support for returning the number of records returned in an SELECT statement, then [[v5:reference:connection: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 =====
<code php>
$SQL = "SELECT * FROM large_table";

$ADODB_COUNTRECS = false;

$db->Execute($SQL);

</code>