Active database size recommendations, Refer to the, Database size recommendations table – DAVIS FMS 3.9.3 DriveRight (8186) User Manual
Page 33

DriveRight FMS Help
|
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
maximum of 1 year of data in the active
database
50
Up to 9 months
Backup data once a month for application
performance. Using
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
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
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
maximum of 1 months of data in the active
database
21