DAVIS FMS DriveRight Database Selection Guide (8186) - Manual (Page 3)

3
Active Database Size Recommendations
The recommendations displayed in the table below are based on tests and
calculations made with these assumptions:
• 10 trips per day per vehicle.
• Trip duration is 1 hour (10 hours driving time per day per vehicle).
• GPS data logged every 10 seconds.
Note: If your fleet size exceeds the scenarios shown, we recommend that you use a multi-user
database. For multi-user databases, theoretically there is no fleet size limit. We
recommend that you back up data once a month, keeping only the amount of data
required for reporting purposes in the active database, typically 3-6 months.
Scenario
Number
of
Vehicles
Active Data
stored in
Database
Remarks and Recommendations
No GPS
25 Up to 1 year
Backup data once a month for application
performance. Using backup options, you
can set a 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 a maximum of 9 months of data in
the active database.
100
Up to 6
months
Backup data once a month for application
performance. Using backup options, you
can set a 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 a maximum of 1 month of data in
the active database.
MS
Access
with GPS
10 Up to 1 month
Backup data every month for application
performance. Using the backup options,
you can set a maximum of 1 month of data
in the active database.
Multi-User
Database
with/with-
out GPS
Un-
limited
3-6 months
Backup data every month without GPS or
once a week with GPS. Using the backup
options, you can set a maximum of 6
months data in the active database.