in reply to Replacing SQL with perl
For instance, I have on numerous
occasions loaded an entire table into a hash
and refrenced data in it directly instead of
doing a join in the SQL query. This in some
cases has helped my program run as much as
20 times faster. This is only appropriate
in some situations, such as when your program
doesn't have to take into account any changes
that might occur in the table in the DB after
it was loaded.
I firmly believe that all the data should be stored inside a RDMBS,
just that sometimes you can achieve a big performance boost by doing
"more work in perl, and less work in SQL".
|
|---|