* Greg Klanderman shaped the electrons to say...

I'm a little surprised the tag reading is so slow (remember my shell
utility takes 20 seconds to dump all the tags), I expect it could be
2-3 times faster, but for it's nowhere close to being the bottleneck.

Your shell utility also doesn't extract nearly the information that our tag
reading does. The shell utility is also written in C. :)

Next step is to look deeper into postCheckAttributes, but I've not
done that yet.

Right - here's where the slow down is, no big surprise. It's where we need to
lookup if we've seen an album / artist / genre before, and update or create
new data in the db.

Going in a somewhat orthogonal direction, I also instrumented the
database code, and have these stats to report:

 operation  number  total time
 =========  ======  ==========
  SELECT    60633    50.3012
  INSERT    27852    24.5248
  UPDATE    10085    10.2031
  DELETE       48     0.0389

So the db operations account for about 85 seconds which is not so bad.

Nope. The trick is reducing the number of DB calls without breaking the logic.

-D
--
<dr.pox> does whistling in the dark make me go blind faster?
_______________________________________________
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/beta

Reply via email to