I need to know what would be the most appropriate dynamic structure to load the records of an ID and a Timestamp of approximately 3000 occurrences. Corresponds to the data of a terminal for the entry or exit of personnel with fingerprints. The values are Id and Timestamp (date and time).
Example:
ID TIMESTAMP
37 01-01-17 12:08:07 AM
17 01-01-17 12:10:15 AM
14 01-01-17 12:44:14 AM
The records are sequential in time. What I need is to extract how many hours each Id has worked per day of the month that corresponds regardless of the number of records that each one has in the day. The clock stores in a Access database, MDB format. I need to read it and register it in Golang .