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

Page 33

Advertising
background image

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

Advertising