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

Bookmark(0)

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?

Related Articles

Need Help?
Click the link below to submit a support ticket
Submit Ticket