in reply to Improving SQL speed

Have a look at MP3::Find and MP3::Find::DB, it might give you some good ideas.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

Replies are listed 'Best First'.
Re^2: Improving SQL speed
by Mad_Mac (Beadle) on Nov 06, 2009 at 13:12 UTC
    Sweet!

    Thanks