Docs For Class adodb

$cliFormat = "%32s => %s \r\n"

[line 230]

Type:

mixed

[ Top ]

$color = '#F0F0F0'

[line 225]

Type:

mixed

[ Top ]

$conn =

[line 224]

Type:

mixed

[ Top ]

$createTableSQL = false

[line 234]

Type:

mixed

[ Top ]

$explain = true

[line 232]

Type:

mixed

[ Top ]

$helpurl = "<a href=http://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#logsql>LogSQL help</a>"

[line 233]

Type:

mixed

[ Top ]

$maxLength = 2000

[line 235]

Type:

mixed

[ Top ]

$sql1 = 'sql1'

[line 231]

Type:

mixed

[ Top ]

$table = '<table border=1 bgcolor=white>'

[line 226]

Type:

mixed

[ Top ]

$tablesSQL = false

[line 229]

Type:

mixed

[ Top ]

$titles = '<tr><td>Parameter</td><td>Value</td><td>Description</td></tr>'

[line 227]

Type:

mixed

[ Top ]

$warnRatio = 90

[line 228]

Type:

mixed

[ Top ]

$_lastLoad =

[line 338]

Type:

mixed

[ Top ]

method CheckMemory [line 490]

void CheckMemory(
)

[ Top ]

method clearsql [line 651]

void clearsql(
)

[ Top ]

method CPULoad [line 339]

void CPULoad(
)

[ Top ]

method CreateLogTable [line 893]

void CreateLogTable(
)

[ Top ]

method DBParameter [line 571]

void DBParameter(

$param)

Parameters:

$param

[ Top ]

method DoSQLForm [line 905]

void DoSQLForm(
)

[ Top ]

method ExpensiveSQL [line 501]

void ExpensiveSQL(
[
$numsql = 10])

Parameters:

$numsql

[ Top ]

method Explain [line 406]

void Explain(

$sql, [
$partial = false])

Overridden in child classes as:

perf_db2::Explain()

perf_mssql::Explain()

perf_mysql::Explain()

perf_postgres::Explain()

Parameters:

	$sql
	$partial

[ Top ]

method HealthCheck [line 812]

void HealthCheck(
[
$cli = false])

Overridden in child classes as:

perf_mssql::HealthCheck()

Parameters:

$cli

[ Top ]

method HealthCheckCLI [line 803]

void HealthCheckCLI(
)

[ Top ]

method InvalidSQL [line 411]

void InvalidSQL(
[
$numsql = 10])

Parameters:

$numsql

[ Top ]

method MemInfo [line 307]

void MemInfo(
)

[ Top ]

method optimizeDatabase [line 1070]

Returns optimizeDatabase(
)

Reorganise current database.

Default implementation loops over all

MetaTables()

and optimize each using

optmizeTable()

method OptimizeTable [line 1056]

Returns OptimizeTable(
string
$table, [int
$mode = ADODB_OPT_LOW])

Reorganise the table-indices/statistics/.. depending on the given mode.

Default Implementation throws an error.

Parameters:

string

$table

table name of the table to optimize

int

$mode

mode optimization-mode

ADODB_OPT_HIGH

for full optimization

ADODB_OPT_LOW

for CPU-less optimization Default is LOW

ADODB_OPT_LOW

[ Top ]

method OptimizeTables [line 1025]

Returns OptimizeTables(
string
0, int
1)

Reorganise multiple table-indices/statistics/..

OptimizeMode could be given by last Parameter

Parameters:

string

table name of the table to optimize

int

mode optimization-mode

ADODB_OPT_HIGH

for full optimization

ADODB_OPT_LOW

for CPU-less optimization Default is LOW

ADODB_OPT_LOW

[ Top ]

method Poll [line 761]

void Poll(
[
$secs = 5])

Parameters:

$secs

[ Top ]

method PollParameters [line 581]

void &PollParameters(
)

[ Top ]

method SplitSQL [line 982]

void SplitSQL(

$sql)

Parameters:

$sql

[ Top ]

method SuspiciousSQL [line 496]

void SuspiciousSQL(
[
$numsql = 10])

Parameters:

$numsql

[ Top ]

method table [line 238]

void table(
[
$newtable = false])

Parameters:

$newtable

[ Top ]

method Tables [line 881]

void Tables(
[
$orderby = '1'])

Overridden in child classes as:

perf_db2::Tables()

perf_mssql::Tables()

perf_mysql::Tables()

Parameters:

$orderby

[ Top ]

method Tracer [line 370]

void Tracer(

$sql)

Parameters:

$sql

[ Top ]

method UI [line 662]

void UI(
[
$pollsecs = 5])

********************************************************************************************

Parameters:

$pollsecs

[ Top ]

method undomq [line 988]

void undomq(

$m)

Parameters:

[ Top ]

method WarnCacheRatio [line 644]

void WarnCacheRatio(

$val)

Parameters:

$val

[ Top ]

method _CPULoad [line 248]

void _CPULoad(
)

[ Top ]

method _DBParameter [line 593]

void _DBParameter(

$sql)

Parameters:

$sql

[ Top ]

method _ExpensiveSQL [line 512]

void _ExpensiveSQL(
[
$numsql = 10])

Parameters:

$numsql

[ Top ]

method _SuspiciousSQL [line 433]

void _SuspiciousSQL(
[
$numsql = 10])

Parameters:

$numsql

[ Top ]

Class: adodb_perf

Class Overview

Variables

Methods

Child classes:

Class Details

Class Variables

$cliFormat = "%32s => %s \r\n"

$color = '#F0F0F0'

$conn =

$createTableSQL = false

$explain = true

$helpurl = "<a href=http://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#logsql>LogSQL help</a>"

$maxLength = 2000

$sql1 = 'sql1'

$table = '<table border=1 bgcolor=white>'

$tablesSQL = false

$titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'

$warnRatio = 90

$_lastLoad =

Class Methods

method CheckMemory [line 490]

method clearsql [line 651]

method CPULoad [line 339]

method CreateLogTable [line 893]

method DBParameter [line 571]

Parameters:

method DoSQLForm [line 905]

method ExpensiveSQL [line 501]

Parameters:

method Explain [line 406]

Parameters:

method HealthCheck [line 812]

Parameters:

method HealthCheckCLI [line 803]

method InvalidSQL [line 411]

Parameters:

method MemInfo [line 307]

method optimizeDatabase [line 1070]

Tags:

method OptimizeTable [line 1056]

Tags:

Parameters:

method OptimizeTables [line 1025]

Tags:

Parameters:

method Poll [line 761]

Parameters:

method PollParameters [line 581]

method SplitSQL [line 982]

Parameters:

method SuspiciousSQL [line 496]

Parameters:

method table [line 238]

Parameters:

method Tables [line 881]

Parameters:

method Tracer [line 370]

Parameters:

method UI [line 662]

Parameters:

method undomq [line 988]

Parameters:

method WarnCacheRatio [line 644]

Parameters:

method _CPULoad [line 248]

method _DBParameter [line 593]

Parameters:

method _ExpensiveSQL [line 512]

Parameters:

method _SuspiciousSQL [line 433]

Parameters: