Don’t forget to reindex your free Purchase Order Software

The embedded database that comes with the free version of SpendMap is ideal for a free PO System like this because it’s super easy to install (the database actually installs itself when you install SpendMap).

But unlike SQL Server and Oracle databases used in our paid version, there’s nothing running on the server to do any behind-the-scenes database maintenance.

So it’s important to reindex the embedded database once in a while.  For details, please see this section of the Online Help…
– PURCHASING > Utility > Database Maintenance > Reindex all tables

If you would like the system to remind you to run the reindex utility from time to time, just enable the first setting in the [Permissions] tab of the User Master File.

And remember, you can also run the reindex operation automatically (unattended) from a task scheduler.  Here’s the Help section…
– System-Wide Features and Information > System Admin and Maintenance > Unattended Mode

FYI – We just finished a new scripting option to make it faster and easier to configure unattended operations…no more need to preconfigure pop-up options for a user account.  One less thing.

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s