in reply to Optimizing Loop

Familiarize yourself with two important tools. First, Devel::NYTProf for profiling your application to determine where it is spending the most time. Second, the MySQL Slow Query Log. If it turns out you're spending a lot of time in the database, check out the book High Performance MySQL, from O'Reilly. There's a lot of good insight therein. But really, first profile. Then optimize.


Dave