Databases Reference
In-Depth Information
The initial screen that appears here is the database
Structure
sub-page. We might
want a different initial sub-page to appear when entering the Database view. This
is controlled by the
$cfg['DefaultTabDatabase']
parameter, and the available
choices are given in the configuration file as comments.
The number of records is obtained using a quick method, the
SHOW
TABLE
STATUS
statement—
not
by using a
SELECT
COUNT(*)
FROM
TABLENAME
. This quick method
is usually accurate, except for
InnoDB
tables, which returns an approximate
number of records. To help get the correct number of records, even for
InnoDB
, the
$cfg['MaxExactCount']
parameter is available. If the approximate number of
records is lower than this parameter's value—by default, 20000—the slower
SELECT
COUNT(*)
method will be used.
Do
not
put a value too high for this parameter. You would get correct
results, but only after waiting for a few minutes, if there are hundreds of
thousands of records in your
InnoDB
table.
Search WWH ::
Custom Search