I'm wondering if you are approaching this the right way. Normally I'm stuffing these $row's into an array and then dereferencing them when I need it.

I usually end up writing something more like:
completely untested sample code follows

while (my $row = $sth->fetchrow_hashref) {
 push(@profiles,$row);
}
[download]

then you deref @profiles as you go

foreach (@profiles) {
 print "$_->{user_id}\n";
}
[download]

A couple of other things I noticed

$storedProfile = {};
does not do what you think it does. It creates a scalar called $storedProfile and assigns to it an empty hashref. It looks like you are not using strict, this would not compile if you were using strict (assuming you wanted an empty hash called %storedProfile). BTW to clear a hash you want to '%storedProfile = ()'

also you can rewrite this

@keys = keys %row;
for (@keys){
[download]

as

foreach (keys %row) {
[download]

Which IMO looks cleaner.



grep

Unix - where you can thrown the manual on the keyboard and get a command