1. Home
  2. Inventory and Item Tracking Software
  3. BACKTRACK
  4. BACKTRACK Problems
  5. BACKTRACK is running slow/sluggish – BACKTRACK Problem

BACKTRACK is running slow/sluggish – BACKTRACK Problem

Summary

The article explains the problem of BACKTRACK 6 is running slow/sluggish and makes recommendations on what to do about it.

Symptoms

BACKTRACK (up to and including version 6) is running slow/sluggish.

Explanation

BACKTRACK versions up to and including 6 were able to use FoxPro as the database.  As a relational database without a server component, FoxPro did need certain fields to be re-indexed from time to time.  FoxPro does not do this automatically so the user will often see BACKTRACK with FoxPro gradually get slower especially when doing searches and look-ups.

Solution

Run a ‘Rebuild’ of the database.

BACKTRACK 2012 and Later:  Main Menu > System Maintenance > Administrator Functions > Rebuild Data Files

Before BACKTRACK 2012:  Main Menu > System Maintenance > Administrator Functions > Rebuild Data Files > Check ‘Clear Deleted Files’ and ‘Rebuild Data Files’ > OK

Additional Comments

BACKTRACK versions after v6 required the use of SQL for the database.  SQL does not require the re-indexing however the option above still exists.

Updated on August 5, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support