Menu

#291 Use bytea type for checksums in database

open
Database (8)
5
2013-03-05
2013-03-05
No

The database currently uses character varying (255) fields for checksums and stores checksums as a hexidecimal string representation. It would make more sense to use a bytea field instead as this data is just a binary field of a certain length (depending on the type of checksum algorithm used). This would result in around half the memory usage for these checksum fields.

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.