Open Bug 977185 Opened 7 years ago Updated 4 years ago

microseconds take quite some space in the database

Categories

(Toolkit :: Places, defect, P3)

defect

Tracking

()

People

(Reporter: mak, Unassigned)

References

(Blocks 1 open bug)

Details

We are storing everywhere PRTime value, those are taking up much more space than what we need, especially cause many of those columns are indexed, so they take double space.
For the purpose of history we don't need microseconds precision, let alone the fact timers may have very low resolution, like 16ms.
Unfortunately while this would save some precious db space, it is also definitely not backwards compatible (even if we could detect and fix bogus times on downgrade/upgrade by detecting times in future)
Priority: -- → P3
You need to log in before you can comment on or make changes to this bug.