Re^2: Improving SQL speed

Thanks. I'll look into that module. I'm not having performance issues per se, but the code seems to parse ~15-20 songs per second, which is ~20 minutes for the 19k file in my mp3 library. Not terrible, but I have a feeling it can be faster. I don't notice an CPU or RAM hit while it's running, but I haven't looked closely.

Mad_Mac

Comment on Re^2: Improving SQL speed

Replies are listed 'Best First'.

Re^3: Improving SQL speed
by CountZero (Bishop) on Nov 03, 2009 at 06:59 UTC

MP3::Find

MP3::Find::DB

~~seconds per song~~

songs per second

Given these circumstances it seems therefore you have indeed some room to improve the speed of your script.

Update: fixed typo.

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

[reply]


Perl-Sensitive Sunglasses
	PerlMonks