Tuning: Number of fields in files

If you keep the number of fields in a database table low and limit the number of records, performance is improved in the following areas:

  • Searching for fields in a dbdict.
  • Compressing and writing records to disk.
  • Decompressing and reading records from disk.
  • Operating client and server communications.
  • Exercising the Load and Unload options.

Key type definitions
Troubleshooting: Database debug
Tuning: Designing keys for queries
Tuning: Improving query speed
Tuning: Key selection algorithms