File Tuning for Model 204 Performance

File Tuning for Model 204 Performance

OZ M204 UG '00
Presentations

Click on any slide to view a linked version of this presentation.

Slide 1: Front

Slide 2: Agenda

Slide 3: Logical File structure

Slide 4: Why 6184

Slide 5: File Control Table

Slide 6: Table A

Slide 7: Table B logical

Slide 8: Table C

Slide 9: Table D

Slide 10: Lists and bitmaps

Slide 11: Existence Bitmap

Slide 12: Ordered Index

Slide 13: Ordered Index Splits

Slide 14: Procedure Dictionary

Slide 15: Table B Page

Slide 16: Table B record

Slide 17: Table B parameters

Slide 18: Record Scan

Slide 19: Field Order Matters

Slide 20: INSERT behaviour

Slide 21: Desired Field Order

Slide 22: Reordering fields w FU

Slide 23: FUEL field reorder example

Slide 24: Why Reorg files

Slide 25: Reorg Motivation

Slide 26: Fast/Reorg

Slide 27: Fast/Reorg OINDEX

Slide 28: Questions

customer service products documentation Year 2000 demos java
articles and presentations calendar Model 204 staff home

E-Mail:
Product and service information
Sirius technical support
Comments on the web site

The Sirius site runs as a Model 204 application using the Janus Web Server.
This page and all contents are Copyright © 2001 by Sirius Software, Inc., Cambridge, MA.