[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