[firebase-br] Migrar IBX para FireDAC

Paulo Geloramo assisinformatica em gmail.com
Sexta Julho 17 12:13:40 -03 2020


Bom dia,

Migrar IBX para FireDAC
Firebird

No FireDAC tem algum componente para retornar informações estatísticas?

Para IBX usava TIBStatisticalService

Alguma sugestão?

Exemplo de retorno do TIBStatisticalService:

Database "C:\Program Files (x86)\Analista\Database\analista.fdb"
Gstat execution time Fri Jul 17 11:53:28 2020

Database header page information:
Flags 0
Checksum 12345
Generation 776
Page size 8192
ODS version 11.2
Oldest transaction 771
Oldest active 772
Oldest snapshot 772
Next transaction 773
Bumped transaction 1
Sequence number 0
Next attachment ID 14
Implementation ID 16
Shadow count 0
Page buffers 10000
Next header page 0
Database dialect 3
Creation date May 26, 2020 19:03:14
Attributes force write

    Variable header data:
*END*


Database file sequence:
File C:\Program Files (x86)\Analista\Database\analista.fdb is the only file

Analyzing database pages ...
AGENDA (128)
    Primary pointer page: 155, Index root page: 156
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

    Index FK_AGENDA_GRUPO (1)
Depth: 1, leaf buckets: 1, nodes: 0

Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0



Mais detalhes sobre a lista de discussão lista