PHP 8.4.0 RC4 available for testing

dba_optimize

(PHP 4, PHP 5, PHP 7, PHP 8)

dba_optimizeOtimiza o banco de dados

Descrição

dba_optimize(Dba\Connection $dba): bool

dba_optimize() otimiza o banco de dados subjacente.

Parâmetros

dba

Uma instância de Dba\Connection, retornada por dba_open() ou dba_popen().

Valor Retornado

Retorna true em caso de sucesso ou false em caso de falha.

Registro de Alterações

Versão Descrição
8.4.0 O parâmetro dba agora espera uma instância deDba\Connection; anteriormente, um resource dba válido era esperado.

Veja Também

adicione uma nota

Notas Enviadas por Usuários (em inglês) 2 notes

up
4
doppelbauer at gmail dot com
18 years ago
The difference between "dba_optimize" and "dba_sync":

Use "dba_optimize" to optimize a database, which usually consists of eliminating gaps between records created by deletes.

The "dba_sync" function will synchronize the view of the database in memory and its image on the disk. As you insert records, they may be cached in memory by the underlying engine. Other processes reading from the database will not see these new records until synchronization.
up
0
samuele at removethisnorsam dot org
21 years ago
Note that the internal structure of each DB that needs to access etherogeneous data in a *fast* way it is not necessarily space-optimized. So, if you add-remove-substitute keys with data having different content length, the db continues to grow, wasting space. So, it is necessary, sometimes, to re-pack the db in order to remove unused data from the db itself. But it is important to remind that, even if the file grows, the data remain optimized and - obviously - the access continues to be fast. Further information are available at dba_replace() user-contributed notes.
To Top