If I understand correctly, you have a single key ($pin) that has an associated hashref as the value. Could you use BerkeleyDB and Storable? This should be pretty fast, is a substitute for in-memory processing, but doesn't then require writing SQL/DBI code and your code could remain hash/tie based.

Sean