C
ChUIMonster
Guest
"leave them around after execution" requires that you use -t and then crash the session. George can explain how to turn the resulting file into a hacked database but that isn't something that most people are going to know how to do. So you mostly end up seeing the file size. Whereas the TT "vst" info and the supporting class library give you relatively easy access to a wealth of useful insight. For instance: ┌─────────────────────────── Temp-Table Info ───────────────────────────┐ │ │ │ │ │ │ │ │ │ │ │ /home/pt3.14/tmp/DBI-1633544128bXGSrh │ │ │ │ │ │ │ │ 4096 DBI Block Size 39 current temp-tables │ │ ┌─────────────────────────────────────────────────────────────────────── Index Activ│ 32768 DBI File Size 6 archived │──┐ │ Idx# Area# BX Index Name Blocks Util │ 520 DBI Total Blocks 89 peak │l │ │ ─────────────────────────────────────────────────────────────────────────────────│ 89 DBI Empty Blocks 95 tt indexes │─ │ │ > 1 6 B1 _File._File-Name 0 0.00% │ 7 DBI Free Blocks 1745 total current records │0 │ │ 2 6 B1 _Field._File/Field 0 0.00% │ 0 DBI RM Free Blocks 121054 total current bytes │0 │ │ 3 6 B1 _Field._Field-Name 0 0.00% │ │0 │ │ 4 6 B1 _Field._Field-Position 0 0.00% │ 99.99% tt hit ratio │0 │ │ 5 6 B1 _Index._File/Index 0 0.00% │ │0 │ │ 6 6 B1 _Index-Field._Index/Number 0 0.00% │ 2347 tt rec create │0 │ │ 7 6 B1 _Index-Field._Field 0 0.00% │ 33320 tt rec read │0 │ │ 8 12 B1 Invoice.InvoiceNum 1 32.70% │ 1254 tt rec update │0 │ │ 9 12 B1 Invoice.CustNum 1 17.70% │ 2 tt rec delete │0 │ │ 10 12 B1 Invoice.InvoiceDate 1 24.50% │ 76660 tt rec log rd │0 │ │ 11 12 B1 Invoice.OrderNum 1 32.70% │ 7 tt rec os rd │0 │ │ 12 10 B1 Customer.CustNum 4 62.20% │ 2 tt rec os wr │0 │ │ 13 10 B1 Customer.Comments 1 22.20% │ 3089 tt TRX │0 │ │ 14 10 B1 Customer.CountryPost 4 56.50% │ 18 tt Undos │0 │ │ 15 10 B1 Customer.Name 9 62.90% │ │0 │ │ 16 10 B1 Customer.SalesRep 1 33.40% │ │0 │ │ 17 8 B1 Item.ItemNum 1 12.40% │ ───────────────────────────────────────────────────────────────────── │0 │ │ 18 8 B1 Item.CatDescription 3 34.50% │ │0 │ │ 19 8 B1 Item.Category2ItemName 1 23.50% └───────────────────────────────────────────────────────────────────────┘0 │ ┌─────────────────────────── Temp-Table Info ───────────────────────────┐ │ │ │ │ │ │ │ │ │ │ │ /home/pt3.14/tmp/DBI-1633544128bXGSrh │ │ │ │ │ │ │ │ 4096 DBI Block Size 39 current temp-tables │ │ ┌─────────────────────────────────────────────────────────────────────── Index Activ│ 32768 DBI File Size 6 archived │──┐ │ Idx# Area# BX Index Name Blocks Util │ 520 DBI Total Blocks 89 peak │l │ │ ─────────────────────────────────────────────────────────────────────────────────│ 89 DBI Empty Blocks 95 tt indexes │─ │ │ > 1 6 B1 _File._File-Name 0 0.00% │ 7 DBI Free Blocks 1745 total current records │0 │ │ 2 6 B1 _Field._File/Field 0 0.00% │ 0 DBI RM Free Blocks 121054 total current bytes │0 │ │ 3 6 B1 _Field._Field-Name 0 0.00% │ │0 │ │ 4 6 B1 _Field._Field-Position 0 0.00% │ 99.99% tt hit ratio │0 │ │ 5 6 B1 _Index._File/Index 0 0.00% │ │0 │ │ 6 6 B1 _Index-Field._Index/Number 0 0.00% │ 2347 tt rec create │0 │ │ 7 6 B1 _Index-Field._Field 0 0.00% │ 33320 tt rec read │0 │ │ 8 12 B1 Invoice.InvoiceNum 1 32.70% │ 1254 tt rec update │0 │ │ 9 12 B1 Invoice.CustNum 1 17.70% │ 2 tt rec delete │0 │ │ 10 12 B1 Invoice.InvoiceDate 1 24.50% │ 76660 tt rec log rd │0 │ │ 11 12 B1 Invoice.OrderNum 1 32.70% │ 7 tt rec os rd │0 │ │ 12 10 B1 Customer.CustNum 4 62.20% │ 2 tt rec os wr │0 │ │ 13 10 B1 Customer.Comments 1 22.20% │ 3089 tt TRX │0 │ │ 14 10 B1 Customer.CountryPost 4 56.50% │ 18 tt Undos │0 │ │ 15 10 B1 Customer.Name 9 62.90% │ │0 │ │ 16 10 B1 Customer.SalesRep 1 33.40% │ │0 │ │ 17 8 B1 Item.ItemNum 1 12.40% │ ───────────────────────────────────────────────────────────────────── │0 │ │ 18 8 B1 Item.CatDescription 3 34.50% │ │0 │ │ 19 8 B1 Item.Category2ItemName 1 23.50% └───────────────────────────────────────────────────────────────────────┘0 │
Continue reading...
Continue reading...
