Database - Optimize

From TNG_Wiki
Jump to navigation Jump to search

TNG Admin >> Utilities provides the capability to optimize your database.

Why Optimize

There are several scenarios where you may want to optimize your database:

  • after deleting several records
  • before doing a new data import

How to optimize your database

To optimize all your tables

  • Go to Admin >> Utilities
  • Click the Select All button
  • Select Optimize from the With Selected pull down list
  • Click the Go button
Optimize All Selected

Related Links

Setup - Database

Database - Creating

Database - Backup

Database - Optimize

Database - Restore