User guide

DriveRight FMS Help
Home | Getting Started | Quick Reference | Menu Commands | Troubleshooting
Active Database Size Recommendations
The following recommendations are based on tests and calculations made with these
assumptions:
o 10 trips per day per vehicle
o Trip duration: 1 hour (10 hours driving time per day per vehicle)
o GPS data logged every 10 seconds
Note: If your fleet size exceeds the scenarios shown below, we recommend that you use a multi-
user database.
Note: For multi-user databases, theoretically there is no fleet size limit. Still, we recommend that
you backup data once a month, keeping only the amount of data required for reporting purposes
in the active database, typically 3-6 months.
Recommendations Table
Scenario Number
of
Vehicles
Amount of
Active
Data in
Database
Remarks and Recommendations
25 Up to 1 year Backup data once a month for application
performance. Using backup options
you can set
maximum of 1 year of data in the active
database
50 Up to 9 months Backup data once a month for application
performance. Using backup options
you can set
maximum of 9 months of data in the active
database
No GPS
100 Up to 6 months Backup data once a month for application
performance. Using backup options
you can set
maximum of 6 months of data in the active
database
MSDE
with GPS
5 Up to 1 month Backup data every month for application
performance. Using backup options
you can set
maximum of 1 months of data in the active
database
MS
Access
with GPS
10 Up to 1 month Backup data every month for application
performance. Using backup options
you can set
maximum of 1 months of data in the active
database
21